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