begin tran
create table t1(a int);
create table t2(b int);
insert into t1 select 1000;
select * from t1
insert into t2 select 'abc'
select * from t2
if @@error =0 begin
print('执行成功')
commit tran
end else begin
print( '执行失败')
rollback tran
end
create table t1(a int);
create table t2(b int);
insert into t1 select 1000;
select * from t1
insert into t2 select 'abc'
select * from t2
if @@error =0 begin
print('执行成功')
commit tran
end else begin
print( '执行失败')
rollback tran
end
create table t1(a int);
create table t2(b int);
insert into t1 select 1000;
select * from t1
insert into t2 select 'abc'
select * from t2
if @@error =0 begin
select '执行成功'
commit tran
end else begin
select '执行失败'
rollback tran
print '执行失败'
end
用raiserror呀。
create table t1(a int);
if @@error <>0 begin
select '执行失败'
rollback tran
return
end
create table t2(b int);
if @@error <>0 begin
select '执行失败'
rollback tran
return
end insert into t1 select 1000;
if @@error <>0 begin
select '执行失败'
rollback tran
return
end select * from t1
if @@error <>0 begin
select '执行失败'
rollback tran
return
end insert into t2 select 'abc'
if @@error <>0 begin
select '执行失败'
rollback tran
return
end select * from t2
if @@error =0 begin
select '执行成功'
commit tran
end else begin
select '执行失败'
rollback tran
end
insert into t2 select 'abc'
就是呀,这句后面的任何语句好像都执行不了
还是要用riseerror好一点吧