SQLServer 存储过程

存储过程模板

-- Template generated from Template Explorer using:
-- Create Procedure (New Menu).SQL
--
-- Use the Specify Values for Template Parameters 
-- command (Ctrl-Shift-M) to fill in the parameter 
-- values below.
--
-- This block of comments will not be included in
-- the definition of the procedure.
-- ================================================
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		<Author,,作者>
-- Create date: <Create Date,,当前时间（yyyy-MM-dd）>
-- Description:	<Description,,描述>
-- =============================================
CREATE PROCEDURE usp_TemplateName 
	-- Add the parameters for the stored procedure here
	@Code int=200 output,
	@Message varchar(8000)='' output,
	@BatchId uniqueIdentifier
AS
BEGIN
	begin try
		begin tran 
		--业务逻辑
		if(@@trancount>0)
		begin
			set @Code=200
			commit tran;        -- 提交事务
		end
	end try
	begin catch
		if(@@trancount>0)    -- @@trancount 系统全局变量，事务开启 @@trancount 值+1，判断事务是否开启
		begin
			rollback tran;        -- 回滚事务
		end
		--print '0'
		set @Code=500
		set @Message=error_message()
		-- print error_message()
	end catch
END
GO