根据表名生成有关SelectAll的存储过程

最新推荐文章于 2024-10-04 22:00:00 发布

立足于世

最新推荐文章于 2024-10-04 22:00:00 发布

阅读量449

点赞数

文章标签：存储 date sql object null

Create PROCEDURE [dbo].[P_CreateProcedure_SelectAll]
@TableName as Varchar(50)
AS
BEGIN

SET LOCK_TIMEOUT 2000;
SET XACT_ABORT ON;
SET NOCOUNT ON;

Declare @Date As Varchar(200)
Set @Date=CONVERT(Varchar, GetDate(),121)

--得到存储过程名称
Declare @ObjectName AS Varchar(100)
Set @ObjectName='P_'+@TableName+'_SelectAll'
--如果存储过程已经存在则删除;
IF OBJECT_ID(@ObjectName)Is Not Null
Begin
Exec('Drop Procedure '+@ObjectName)
END
Declare @SQL nvarchar(max)
Set @SQL = N'
------------------------------------------------------
--Author:<Meng>
--Create Date:<'+@Date+'>
--Description:<SELECT * FROM ' + @TableName + '>
--Return Value:<0:执行成功>;
------------------------------------------------------
CREATE PROCEDURE [dbo].[P_'+@TableName+'_SelectAll]
AS

SELECT * FROM [dbo].['+@TableName+'] With(nolock)

RETURN 0
'
EXEC (@SQL)
Return 0
END