这是找出所有含NAME列的表:
select a.name from sysobjects a,syscolumns b where a.xtype='U' and a.id=b.id and b.name='name'
select a.name from sysobjects a,syscolumns b where a.xtype='U' and a.id=b.id and b.name='name'
调试欢乐多
declare AAA CURSOR FOR
select a.name from sysobjects a,syscolumns b where a.xtype='U' and a.id=b.id and b.name='name'
open AAA
fetch next from AAA into @temp
while @@fetch_status=0
begin
exec ('insert 你的表 (Name) select Name from '+@temp)
fetch next from AAA into @temp
end
close AAA
deallocate AAA