Database practical Script 1 --- query the table names with data in the database and the number of rows in the table, 1 --- number of rows

Database practical Script 1 --- query the table names with data in the database and the number of rows in the table, 1 --- number of rows

Create table # Temp
(
Name varchar (30 ),
Num int
)

Declare @ Name varchar (30)
Declare @ SQL varchar (1000)

Declare D_cursor Cursor
Select name from sysobjects where xtype = 'U'

Open D_cursor

Fetch Next from D_Cursor into @ Name
While @ Fetch_Status = 0
Begin
Set @ SQL = 0
Set @ SQL = 'select' + @ Name + ''', count (*) from '+ @ Name +''
-- Print @ SQL
Insert into # Temp exec (@ SQL)

Fetch Next from D_Cursor into @ Name
End
Close D_Cursor
Deallocate D_cursor

Select * from # Temp

Drop table # Temp