declare @tb varchar(50)
declare c cursor for
select name from sysobjects where xtype='U' and name<>'dtproperties'
open c
fetch next from c into @tb
while @@fetch_status=0
begin
print @tb
fetch next from c into @tb
end
close c
deallocate c
MSSQL遍历数据表
最新推荐文章于 2020-12-19 23:32:58 发布