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
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.