Number of records in the table

 

Self-written declare @ count int
Declare @ sqlstring nvarchar (500)
, @ Tablename varchar (100)
Select top 1 @ tablename = Name from sysobjects where xtype = 'U'
Select @ sqlstring = 'select @ innercount = count (1) from' + @ tablename

Execute sp_executesql
@ Sqlstring
, N' @ innercount int output'
, @ Innercount = @ count output
Select @ tablename + 'number of records: '+ Cast (@ count as varchar (20): declare @ name varchar (200)
Declare @ I int
Declare @ result table (name varchar (100 ))
Declare @ s nvarchar (100)
Declare a cursor for (Select name from sysobjects where type = 'U') open
Fetch next from a into @ name
While @ fetch_status = 0
Begin
Set @ s = 'select top 10 @ I = count (1) from '+ @ name +''
Exec sp_executesql @ s, n' @ I int output', @ I
Output
If @ I> 0
Insert into @ result select @ name
Fetch next from a into @ name
End
Close
Deallocate
Select * From @ result