var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Always use explicit transactions?
In today's newletter from SQL-Server-Performance.Com, Brad McGehee wrote
I disagree. If I have an update of a single row in a stored procedure, there is no need to do an explicit BEGIN/COMMIT.
Here are some ways to help keep transactions as short as possible:
Always manage your transaction by beginning and ending your transaction explicitly. Do not use implicit transactions.
If someone knows why this stored procedure would benefit from an explicit BEGIN/COMMIT pair, please explain.
CREATE PROCEDURE UpdateAuthorLastName (
SET NOCOUNT ON
SET au_lname = @newLastName
WHERE au_id = @au_id
-- Error check