SQLServer在多个表中都增加一个字段的方法

declare @sql varchar(), @name varchar()
declare my_cursor scroll cursor for
select name from sysobjects where type = 'u' and name like 'jobs_%'
open my_cursor
fetch next from my_cursor into @name
while(@@fetch_status=)
begin
print 'processing ' + @name
set @sql = N'alter table testbfcmisuser.' + @name + N' add note varchar(200)'
exec(@sql)
print 'finished'
fetch next from my_cursor into @name
end
close my_cursor
deallocate my_cursor

declare @sql varchar(), @name varchar(), @count intselect identity(int, , ) as ID, name
into #JobTable
from sysobjects
where type = 'u' and name like 'Jobs_%'set @count=@@rowcountwhile @count>
begin
select top @name = name
from #JobTable
where id = @count print 'processing ' + @name
set @sql = N'alter table testbfcmisuser.' + @name + N' add note varchar(200)'
exec(@sql)
print 'finished'
set @count = @count -
enddrop table #JobTablehttp://www.wonima.com 喔尼玛网，搞笑网站