BEGIN/END block needed in SPs? | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

BEGIN/END block needed in SPs?

Hi, Since I’ve been coding stored procedures, I’ve always began and ended my procs with BEGIN/END blocks. Someone just pointed out to me that those are not necessary for the procedure to compile. My question is, is there any difference (performance or otherwise) if the block is included or not? Thanks~ H
Performance wise no. I just like that practice. It is more readable IMO.
True andhttp://www.codeproject.com/database/sqlservertransactions.asp for reference on transactions and error handling. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
]]>