34,576
社区成员
发帖
与我相关
我的任务
分享
IF 1=1
BEGIN
CREATE PROCEDURE [test_procedure_name]
@parameter_name AS INT
AS
BEGIN
SELECT @parameter_name*@parameter_name
END
END
USE tempdb
GO
DECLARE @sql NVARCHAR(MAX)
IF NOT EXISTS(SELECT 1 FROM sys.procedures AS p WHERE p.[object_id]=OBJECT_ID('Proc_Test'))
BEGIN
SET @sql='
-- =============================================
-- Author: yenange
-- Create date: 2019-10-24
-- Description: 测试存储过程
-- =============================================
CREATE PROCEDURE dbo.Proc_Test
AS
BEGIN
set nocount on
print ''你看还行不??'';
END
'
EXEC(@sql);
PRINT '添加存储过程完毕.'
END
ELSE
BEGIN
PRINT '存储过程已存在,不作任何处理.'
END
--执行测试存储过程
EXEC Proc_Test