begin try
DECLARE @Message VARCHAR(200)
DECLARE @MaxUserCode INT
BEGIN TRANSACTION ADM_UPD_SalesUserDetails
IF 1=0
BEGIN
SET @Message = 'fail'
RAISERROR(@Message,16,1)
END
insert into test values(1,'pass') commit TRANSACTION ADM_UPD_SalesUserDetails
end try
begin catch IF @@TRANCOUNT > 0 ROLLBACK TRANSACTION ADM_UPD_SalesUserDetails
if @Message='fail' select 'insert' else select 'ok' end catch
Aucun commentaire:
Enregistrer un commentaire