2024年4月28日发(作者：)

FETCH NEXT FROM tnames_cursor INTO @tablename

WHILE (@@FETCH_STATUS <> -1)

BEGIN

IF (@@FETCH_STATUS <> -2)

BEGIN

SELECT @tablename = RTRIM(@tablename)

EXEC ('SELECT ''' + @tablename + ''' = count(*) FROM '

+ @tablename )

PRINT ' '

END

FETCH NEXT FROM tnames_cursor INTO @tablename

END

CLOSE tnames_cursor

DEALLOCATE tnames_cursor