高手帮忙看下,我下面的存储过程要在哪里设置回滚点?咋写?use bookManage
go
create proc addBooks_pro
@ISBN varchar(30),
@name varchar(40),
@publisher Varchar(40),
@p float,
@num int,
@bookBusiness varchar(40),
@t varchar(20)
as
if exists(select * from book_now_num where bookID=@ISBN)
begin
update book_now_num set nowNum=nowNum+@num where bookID=@ISBN
insert into books(bookID,amount,byfrom,time) values(@ISBN,@num,@bookBusiness,@t)
end
else
begin
insert into book_now_num values(@ISBN,@num)
insert into bookInfo values(@ISBN,@name,@publisher,@p)
insert into books(bookID,amount,byfrom,time) values(@ISBN,@num,@bookBusiness,@t)
end
go
go
create proc addBooks_pro
@ISBN varchar(30),
@name varchar(40),
@publisher Varchar(40),
@p float,
@num int,
@bookBusiness varchar(40),
@t varchar(20)
as
if exists(select * from book_now_num where bookID=@ISBN)
begin
update book_now_num set nowNum=nowNum+@num where bookID=@ISBN
insert into books(bookID,amount,byfrom,time) values(@ISBN,@num,@bookBusiness,@t)
end
else
begin
insert into book_now_num values(@ISBN,@num)
insert into bookInfo values(@ISBN,@name,@publisher,@p)
insert into books(bookID,amount,byfrom,time) values(@ISBN,@num,@bookBusiness,@t)
end
go
解决方案 »
- struts2 action获取不到jsp上面的值
- weblogic 部署项目成功,但是再界面上取不到数据
- 用jsp画了张图,windows下显示正常,但放到linux里就显示不出。
- eWebEditor问题
- session传对象的问题
- 问一个特幼稚的问题,如何更改JSP默认的站点?????????????
- request对象
- 新手求教!如何启动web程序?
- 难为我了,大家帮帮忙吧
- 怎样用jsp做一个简单的关键字全文搜索,只要搜索一个目录中的文件即可(全是.htm文件)
- 字符串中的HTML转义字符,比如(& # 25289; ),如何转化为汉字! JSP或者JAVA环境!
- 怎么做一个验证两个text组件值大小的脚本
....
}else{
....
}
EXCEption
rollback to ;
go
create proc addBooks_pro
@ISBN varchar(30),
@name varchar(40),
@publisher Varchar(40),
@p float,
@num int,
@bookBusiness varchar(40),
@t varchar(20)
as
savepoint:;
if exists(select * from book_now_num where bookID=@ISBN)
begin update book_now_num set nowNum=nowNum+@num where bookID=@ISBN
insert into books(bookID,amount,byfrom,time) values(@ISBN,@num,@bookBusiness,@t)
end else
begin insert into book_now_num values(@ISBN,@num)
insert into bookInfo values(@ISBN,@name,@publisher,@p)
insert into books(bookID,amount,byfrom,time) values(@ISBN,@num,@bookBusiness,@t)
endEXCEption
rollback to ;
go 这样吗?不对啊???