34,587
社区成员
发帖
与我相关
我的任务
分享CREATE 问题
CREATE procedure b
Begin
BEGIN TRANSACTION t1
insert into a(a,b)
values ('a','b')
if @@error <> 0 goto PROBLEM
insert into b (c,d)
values ('c','d')
if @@error <> 0 goto PROBLEM
insert into c (e,f)
values ('e','f')
if @@error <> 0 goto PROBLEM
Commit Transaction t1 return
PROBLEM: Rollback Transaction t1
return
END
Begin
BEGIN TRANSACTION t1
insert into a(a,b)
values ('a','b')
if @@error <> 0 goto PROBLEM
insert into b (c,d)
values ('c','d')
if @@error <> 0 goto PROBLEM
insert into c (e,f)
values ('e','f')
if @@error <> 0 goto PROBLEM
Commit Transaction t1 return
PROBLEM: Rollback Transaction t1
return
END
...全文
请发表友善的回复…
发表回复
ping3000 2006-03-24
- 打赏
- 举报
在CREATE procedure b 后面加个 AS
CREATE procedure b
AS
Begin
BEGIN TRANSACTION t1
insert into a(a,b)
values ('a','b')
if @@error <> 0 goto PROBLEM
insert into b (c,d)
values ('c','d')
if @@error <> 0 goto PROBLEM
insert into c (e,f)
values ('e','f')
if @@error <> 0 goto PROBLEM
Commit Transaction t1 return
PROBLEM: Rollback Transaction t1
return
END
CREATE procedure b
AS
Begin
BEGIN TRANSACTION t1
insert into a(a,b)
values ('a','b')
if @@error <> 0 goto PROBLEM
insert into b (c,d)
values ('c','d')
if @@error <> 0 goto PROBLEM
insert into c (e,f)
values ('e','f')
if @@error <> 0 goto PROBLEM
Commit Transaction t1 return
PROBLEM: Rollback Transaction t1
return
END
