sql进阶-筛选库表中数据为空的表
标签：pre style locate eal dealloc body exec nvarchar ext
sql进阶-筛选库表中数据为空的表
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