create procedure demo @input int as declare @transcounter int set @transcounter=@@TRANCOUNT IF @@TRANCOUNT>0 save tran demo else begin try delete emp where empid='1' commit tran;
create procedure demo1 @input int as declare @transcounter int set @transcounter=@@TRANCOUNT IF @@TRANCOUNT>0 save tran demo else begin try delete emp where empid='1' commit tran END TRY BEGIN CATCH END CATCH;
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)