UC知道SQL事务的问题
来源：百度知道 编辑：UC知道 时间：2024/06/03 06:16:16
CREATE PROCEDURE OUTman
@sfzheng nvarchar(50)
AS
begin tran
delete from gerenziliao where 身份证 = @sfzheng
if @@error<>0
begin
rollback tran
return @@error
end
else
insert into lizhiyuangong select gerenziliao.*, getdate() as 登记时间 from gerenziliao where 身份证 = @sfzheng
commit tran
GO
能删除数据,但是插入无效
二楼的运行和我的代码结果一样,都是插入无效
@sfzheng nvarchar(50)
AS
begin tran
delete from gerenziliao where 身份证 = @sfzheng
if @@error<>0
begin
rollback tran
return @@error
end
else
insert into lizhiyuangong select gerenziliao.*, getdate() as 登记时间 from gerenziliao where 身份证 = @sfzheng
commit tran
GO
能删除数据,但是插入无效
二楼的运行和我的代码结果一样,都是插入无效
CREATE PROCEDURE OUTman
@sfzheng nvarchar(50)
AS
@sumerror int
set @sumerror = 0
begin tran
delete from gerenziliao where 身份证 = @sfzheng
set @sumerror = @sumerror + @@error
insert into lizhiyuangong select gerenziliao.*, getdate() as 登记时间 from gerenziliao where 身份证 = @sfzheng
if @@error<>0
rollback tran
else
commit tran
GO
把登记时间后的那个FROM语句给删除掉，只留WHERE部分试试…