Usage of @@Error within transaction
@@ERROR returns error number of the last statement executed. When the last executed statement completed successfully, this returns 0. In case of any error, the error number will be return….
Read more »Table variable and Table type in transaction
The myth is to roll back the work done inside the transaction, in case of any error during the transaction. However this is not the case with the SQL Server…
Read more »