/*取用表信息游*/
SET NOCOUNT ON
DECLARE find_user_table CURSOR
FOR
SELECT [name],crdate FROM sysobjects
WHERE type='U' /*只查用定的表*/
ORDER BY [name]

DECLARE @cName VARCHAR(128) /*定存表名量*/
DECLARE @crdate DATETIME /*定表建日期量*/
DECLARE @Rows INT /*定表行量*/

CREATE TABLE #tmpTable /*建用存信息的表*/
(
Tablename VARCHAR(128),
crDate datetime,
Row INT
)
OPEN find_user_table /*打游*/
FETCH NEXT FROM find_user_table INTO @cName,@crdate /*游中取表名到量*/
WHILE @@FETCH_STATUS=0
BEGIN
DECLARE @cSql nvarchar(500),@par nvarchar(30)
SELECT @par='@nRows INT OUTPUT'
SELECT @cSql='SELECT @nRows=COUNT(*) FROM ['+@cName+']'
EXECUTE sp_executesql @cSql,@par,@rows OUTPUT /*算前表的行*/

INSERT INTO #tmpTable valueS(@cName,@crdate,@rows) /*前表信息存到表*/
FETCH NEXT FROM find_user_table INTO @cName,@crdate /*游中取表名到量*/
END
SELECT * FROM #tmpTable /*示所有表信息*/
DROP TABLE #tmpTable /*除表*/
CLOSE find_user_table /*游*/
DEALLOCATE find_user_table /*放游*/

EiVHTML5中文学习网 - HTML5先行者学习网
EiVHTML5中文学习网 - HTML5先行者学习网