Access to SQL Server user table information cursor

Server/* Access to User table information travel target
SET NOCOUNT on
DECLARE find_user_table CURSOR
For
SELECT [name],crdate from sysobjects
WHERE type= ' U '/* Here only refer to the User Defined table * *
Order BY [name]

DECLARE @cName VARCHAR (128)/* Definition Storage table name change *
DECLARE @crdate DATETIME/* Definition table creation Date Change *
DECLARE @Rows INT/* Definition table row number Change *

CREATE TABLE #tmpTable/* Create a temporary schedule for storing information
(
TableName VARCHAR (128),
Crdate datetime,
Row INT
)
Open find_user_table//* Open the target * *
Fetch NEXT from find_user_table into @cName, @crdate/* Read the table name from the cursor to the variable *
While @ @FETCH_STATUS =0
BEGIN
DECLARE @cSql nvarchar (+), @par nvarchar (30)
SELECT @par = ' @nRows INT OUTPUT '
Select @cSql = ' Select @nRows =count (*) from [' + @cName + '] '
EXECUTE sp_executesql @cSql, @par, @rows OUTPUT/* Calculates the total number of the preceding table * *

INSERT into #tmpTable ValueS (@cName, @crdate, @rows)/* To save the information in the preceding table to a temporary form *
Fetch NEXT from find_user_table into @cName, @crdate/* Read the table name from the cursor to the variable *
End
SELECT * FROM #tmpTable/* Displays all table information * *
DROP Table #tmpTable/* Delete temporary table * *
Close Find_user_table/* Close the cursor/*
DEALLOCATE find_user_table/* Release the Tour target * *