Declare @s varchar(50),@p varchar(1000)
Declare kk cursor for
select name from sysobjects where xtype='U'
open kk
fetch next from kk into @s
while @@fetch_status=0
begin
set @p='if not exists(select * from '+@s +' ) select ''' + @s+''''
exec(@p)
fetch next from kk into @s
end
close kk
deallocate kk
Declare kk cursor for
select name from sysobjects where xtype='U'
open kk
fetch next from kk into @s
while @@fetch_status=0
begin
set @p='if not exists(select * from '+@s +' ) select ''' + @s+''''
exec(@p)
fetch next from kk into @s
end
close kk
deallocate kk
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货