这个交易怎么写?

[houzy123]

我的意思是一旦删除@zcl,将相关的几个表同时删除
CREATE PROCEDURE delete_zcl
@zcl varchar(20)
AS
if @zcl is not null
begin
begin transaction
delete from cb_djb where zcl=@zcl --可能不存在zcl=@zcl的记录
delete from cb_header where zcl=@zcl
delete from djb where zcl=@zcl
delete from dibparent where zcl=@zcl
if @@ERROR!=0
begin
ROLLBACK transaction
end
commit tran
end
GO

[CrazyFor]

CREATE PROCEDURE delete_zcl
@zcl varchar(20)
AS
declare @err int
set @err=0
if @zcl is not null
begin
begin transaction
delete from cb_djb where zcl=@zcl --可能不存在zcl=@zcl的记录
if @@erroe<>0
@err=1
delete from cb_header where zcl=@zcl
if @@erroe<>0
@err=1

delete from djb where zcl=@zcl
if @@erroe<>0
@err=1

delete from dibparent where zcl=@zcl
if @@erroe<>0
@err=1

if @err=1
begin
ROLLBACK transaction
end
commit tran
end
GO

[liuyun2003]

CREATE PROCEDURE delete_zcl
@zcl varchar(200)
AS
if @zcl is not null
begin
begin transaction
delete cb_djb where zcl=@zcl
if @@ERROR<>0
begin
ROLLBACK transaction
end

delete cb_header where zcl=@zcl
if @@ERROR<>0
begin
ROLLBACK transaction
end

delete djb where zcl=@zcl
if @@ERROR<>0
begin
ROLLBACK transaction
end

delete dibparent where zcl=@zcl
if @@ERROR<>0
begin
ROLLBACK transaction
end
else
begin
commit tran
end
end
GO

[愉快的登山者]

CREATE PROCEDURE delete_zcl
@zcl varchar(20)
AS
if @zcl is not null
begin
begin transaction
delete from cb_djb where zcl=@zcl --可能不存在zcl=@zcl的记录
if @@ERROR!=0
begin
ROLLBACK transaction
return
end
delete from cb_header where zcl=@zcl
if @@ERROR!=0
begin
ROLLBACK transaction
return
end
delete from djb where zcl=@zcl
if @@ERROR!=0
begin
ROLLBACK transaction
return
end
delete from dibparent where zcl=@zcl
if @@ERROR!=0
ROLLBACK transaction
else
commit transaction
end
return
GO