MsSQL记录
时间：2010-09-20 来源：丰色日月
- 得到数据库中各表格的数据量大于0的表格
SQL
1 DECLARE @tbname VARCHAR(250)2 DECLARE #tb CURSOR FOR SELECT name FROM sysobjects WHERE OBJECTPROPERTY(id,'IsUserTable')=1
3 OPEN #tb
4 FETCH NEXT FROM #tb INTO @tbname
5 WHILE @@fetch_status = 0
6 BEGIN
7 EXEC ('
8 declare @count int
9 select @count = count(*) from '+@tbname+'
10 if @count>0
11 print Str(@count,5)+'' ''+'''+@tbname+'''
12 ')
13 FETCH NEXT FROM #tb INTO @tbname
14 END
15 CLOSE #tb
16 DEALLOCATE #tb
相关阅读 更多 +
