sql进阶-筛选库表中数据为空的表
时间：2021-07-01 10:21:17
帮助过：7人阅读
100)
declare @sql nvarchar(2000)
declare @count int
declare @a int
declare cur_c cursor for
select name
from sysobjects
where xtype=
‘U‘ and status>=
0
open cur_c
fetch next from cur_c into @tablename
while @@fetch_status =
0
begin
set @sql=
‘select @a=count(*) from ‘+@tablename+
‘‘
exec sp_executesql @sql,N‘@a int output‘,@count output
if @count=
0
print @tablename
fetch next from cur_c into @tablename
end
close cur_c
deallocate cur_c
sql进阶-筛选库表中数据为空的表
标签：pre style locate eal dealloc body exec nvarchar ext
