SQL 存储过程回滚

--创建表

create table Course 

(
No INT,
Name nvarchar(10),
Comment nvarchar(10)

)

--插入数据

insert into course values('332','语言在','234')

insert into course values('332','语言在','234')

--创建存储过程

CREATE proc sp_Insert_Course  
@No char(10),  
@Name varchar(20),  
@Comment varchar(50)  
as  
begin tran
    begin try
DELETE Course
insert into Course values(12,@Name,@Comment)  
insert into Course values(@No,@Name,@Comment)  
    commit tran
    end try
begin catch
   rollback
end catch

--执行语句

exec sp_Insert_Course '1','语文',''   --成功 

exec sp_Insert_Course 'F','语文',''   --回滚

--可例行手复制执行