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

 

posted @ 2013-07-24 14:58  --宁静以致远--  阅读(187)  评论(0编辑  收藏  举报