title: Is it possible to Add column to multiple table simultaneously?
body: <p>I am using SQL Server. I want to add a single column named [DateCreated] to multiple tables. Is it possible that with a single statement I could add this column to all the tables in my database?</p>
  
  <p>I stumble upon an answer by Joe Steffaneli in which he suggested a query which in turn returns rows consisting Alter table statements. 
  Query is as follows : </p>
  
  <pre><code>select 'alter table ' + quotename(s.name) + '.' + quotename(t.name) + ' add [DateModified] datetime'
      from sys.columns c
          inner join sys.tables t
              on c.object_id = t.object_id
          inner join sys.schemas s
              on t.schema_id = s.schema_id
          left join sys.columns c2
              on t.object_id = c2.object_id
                  and c2.name = 'DateModified'
      where c.name = 'DateCreated'
          and t.type = 'U'
          and c2.column_id is null /* DateModified column does not already exist */ 
  </code></pre>
  
  <p>Is there any way that I can execute returned rows? Sorry for English. </p>