1.一个简单事务
1.一个简单事务
CREATE PROCEDURE Pro_Insert(
@id varchar(5),
@name varchar(20))
as
declare @ExistFlag int
set @ExistFlag=(select count(*) from t where id=@id)
begin transaction DoInsert
insert into t(id,name) values(@id,@name)
if @ExistFlag > 0 rollback transaction DoInsert
else commit transaction DoInsert
go