查询所有表数据行

 

DECLARE @FID INT
Declare @TName varchar(50)
Declare cur_Depart Cursor
For Select name,ID From sysobjects Where xtype ='U' AND NAME NOT IN ('ACCESS_T_VOUCHERGROUP','CB_BMERRCODE','ICPRCPLY','ICSTJGBILLENTRY') ORDER BY ID
Open cur_Depart
Fetch From cur_Depart into @TName,@FID
While @@Fetch_Status=0
Begin
Declare @Sql nvarchar(500)

PRINT @TName+'_____S'+'___________'+CONVERT(VARCHAR(200),@FID)
Declare @Count int
set @Sql='select @c=count(1) from '+@TName
exec sp_executesql @Sql,N'@c int output',@Count output
if (@Count>0) print @TName+'_______'+CONVERT(varchar(200),@Count)
PRINT @TName+'____________________________E'
Fetch From cur_Depart into @TName,@FID
End
Close cur_Depart
Deallocate cur_Depart