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