set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[sp_insert2]
@find varchar(50),
@strCondition varchar(50) = ''
AS
BEGIN
update Aucclass set ClassAucAmount=@find
update Aucclass set ClassAucAmount=@strConditionSET XACT_ABORT ON;
END
如果其中一条失败 就回滚 怎么写
set QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[sp_insert2]
@find varchar(50),
@strCondition varchar(50) = ''
AS
BEGIN
update Aucclass set ClassAucAmount=@find
update Aucclass set ClassAucAmount=@strConditionSET XACT_ABORT ON;
END
如果其中一条失败 就回滚 怎么写
set QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[sp_insert2]
@find varchar(50),
@strCondition varchar(50) = ''
AS
BEGIN
begin transaction
begin try
update Aucclass set ClassAucAmount=@find
update Aucclass set ClassAucAmount=@strCondition
commit;
return 1;
end try
begin catch
rollback;
end catchSET XACT_ABORT ON;
END
试下