Declare @tablename varchar( -) ,@sql varchar( +) ,@dbname varchar( -)Set @dbname=db_name()DeclareAddcolumn_cusorcursor for SelectName fromsys.tablesOpenAddcolumn_cusorFetch Next fromAddcolumn_cusor into @tablename while(@ @fetch_status=0)beginSet @sql='IF not EXISTS (SELECT 1 from'+@dbname+'. dbo. syscolumns WHERE id=object_id (" "+@dbname+'. dbo.'+@tablename+" ") and Name="'CreateDate"')'Set @sql += 'ALTER TABLE'+@tablename+'Add createdate datetime default (GETDATE ())'Set @sql+='IF not EXISTS (SELECT 1 from'+@dbname+'. dbo. syscolumns WHERE id=object_id (" "+@dbname+'. dbo.'+@tablename+" ") and Name="'Creator"')'Set @sql += 'ALTER TABLE'+@tablename+'add Creator nvarchar ()'Set @sql+='IF not EXISTS (SELECT 1 from'+@dbname+'. dbo. syscolumns WHERE id=object_id (" "+@dbname+'. dbo.'+@tablename+" ") and Name="'updatedate"')'Set @sql += 'ALTER TABLE'+@tablename+'Add updatedate datetime default (GETDATE ())'Set @sql+='IF not EXISTS (SELECT 1 from'+@dbname+'. dbo. syscolumns WHERE id=object_id (" "+@dbname+'. dbo.'+@tablename+" ") and Name="'Updator"')'Set @sql += 'ALTER TABLE'+@tablename+'add updator nvarchar ()'exec(@sql)Fetch Next fromAddcolumn_cusor into @tablenameEndCloseAddcolumn_cusordeallocateAddcolumn_cusor
Batch to database table plus fields