/****** Object: StoredProcedure [dbo].[Proc_Test_commit1] Script Date: 2019/6/21 9:50:14 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[Proc_Test_Commit]
@Name CHAR(10),
@Salary INT,
@result int output, --成功 1; 失败 0
@message nvarchar(20) output
AS
BEGIN
SET NOCOUNT ON
declare @Test_Commit table(Name CHAR(10),Salary INT CHECK (Salary<5000)) --定义表变量,为测试方便增加Salary字段约束小于5000
begin try
begin tran T_ImportData --事务开始
insert into @Test_Commit (Name,Salary) values (@Name,@Salary)
set @result=1
commit tr