I have found some SP(stored procedure) written as,
CREATE PROCEDURE [dbo].[XXX]
(
-- Parameters
)
BEGIN
--- Actual Work
END
and some as
CREATE PROCEDURE [dbo].[XXX]
(
-- Parameters
)
--- Actual Work
What makes it difference?
Sql-server – Difference Between SP with BEGIN/END and without BEGIN/END
sql servert-sql
Related Question
- SQL Server – Setting User Permissions for Different Schemas
- SQL Server – Difference Between character_maximum_length and character_octet_length
- SQL Server Query – Get Logs Between Start and End Night Hours
- SQL Server 2012 – How to Add Logging Statements to Stored Procedures
- Handling ‘Transaction Count After EXECUTE’ Error in SQL Server
- SQL Server – Ignoring Null Variables in Stored Procedure
- SQL Server TSQL – Begin and GO
Best Answer
There is no difference. That is, it's optional.
What matters is the "end of the batch" which is denoted in SQL Server Management Studio by
GO