Hello everyone,
Two basic questions about transactions,
1. For single SQL insert/update/delete statement, are there any needs or benefits to wrap into a transaction?
2. I wrote T-SQL like this,
[Code]BEGIN TRYBegin Transaction...commitEND TRYBEGIN CATCHrollback...END CATCH[/Code]
my question is, is it a must to call commit explicitly just before end try statement? Any means to commit transaction automatically after end try statement?
regards,George