摘要:
直接上SQL脚本CREATE PROCEDURE dbo.ShowAllTableRows @databaseName NVARCHAR(100)ASBEGIN --declare @databaseName nvarchar(100) --set @databaseName = 'tempdb' DECLARE @dynamicSql NVARCHAR(4000) SET @dynamicSql = N'USE ' + @databaseName + N'; SET NOCOUNT ON; DECLARE cur CURSOR LOCAL FORWAR 阅读全文