sp_getTable_data

CREATE PROC sp_Select_Table 
   @TableName NVARCHAR(200) 
AS 
    if charindex(' ', @TableName)<=0 
    begin 
          DECLARE @sql NVARCHAR(1000) 
          SET @sql='SELECT * FROM ' + @TableName 
          EXEC (@sql) 
    end

GO

 

转载于:https://www.cnblogs.com/myjacky/p/3210698.html