--创建表
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','语文','' --回滚
--可例行手复制执行