Hi All,
SQL Server 2016 version
I am using procedure code with following format
BEGIN TRY
BEGIN TRANSACTION
SQL INSERT STATEMENTS
COMMIT TRANSACTION
END TRY
BEGIN CATCH
IF @@trancount > 0 ROLLBACK TRANSACTION
END CATCH
My question is how to stop using @@trancount in procedure code? Any alternative for @@trancount ??
T.I.A