Is there a MS SQL Server best practices for writing SPs artice or book?
Is it considdered good practice to wrap even singe statements in a transaction. Something like this:
BEGIN TRANSACTION
UPDATE mytable SET Name = @Name WHERE Id = @Id
END TRANSACTION
RETURN @@ERROR
Or is the transaction simply redundant?
Einar
Semper ubi sub ubi.