vendredi 1 septembre 2017

how query with try_catch executes with if else statements as show below

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