创建存储过程时参数说明

USE [AlarmRelation] –使用哪个库
GO

/****** Object: StoredProcedure [dbo].[DoSomething2] Script Date: 2019/2/25 11:33:17 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

–备注信息
– =============================================
– Author: <Author,Name>
– Create date: <Create Date,>
– Description: <Description,>
– =============================================
CREATE PROCEDURE [dbo].[DoSomething2]–存储过程名称
– Add the parameters for the stored procedure here –调用存储过程时，从外面传入的参数名称
@name varchar(50),
@sql varchar(1000),
@sql1 varchar(1000)
AS
BEGIN
–一些sql语句
– SET NOCOUNT ON added to prevent extra result sets from
– interfering with SELECT statements.
SET NOCOUNT ON;–不返回影响的行数，以减少网络传输的流量进而提高性能

-- Insert statements for procedure here
set @sql1 = 'drop table '+@name;

print(@sql1)–打印日志
exec(@sql1)–执行存储过程语句
set @name =‘AlarmCountConfig_’+convert(varchar(120), getdate(),112);
set @sql = ‘select top 1 * into ‘+@name+’ from AlarmCountConfig’;
END

GO–事务提交