"CREATE SPNAME AS PROCEDURE" and "CREATE SPNAME AS BEGIN / END PROCEDURE"

Question

When creating a stored procedure, is the BEGIN / END block used and intended?

eg,

CREATE PROCEDURE SPNAME
AS
  SELECT * FROM TABLE

against.

CREATE PROCEDURE SPNAME
AS
BEGIN
  SELECT * FROM TABLE
END

Answer 1

As stated in the CREATE PROCEDURE documentation , BEGIN / END is optional:

{[BEGIN] sql_statement [;] [... n] [END]}

One or more Transact-SQL statements containing a procedure. You can use the optional BEGIN and END Keywords to enclose statements. For more information, see Recommendations, General Comments, and Limitations and Limitations that follow.

As a personal preference, I always turn them on.

Answer 2

. , BEGIN TRY - END TRY BEGIN CATCH - END CATCH, .

Answer 3

- . , .

, , BEGIN END ( ).

Answer 4

. , BEGIN/END.

Answer 5

BEGIN END , .

:

CREATE PROC dbo.sproc(@v varchar(10))
AS
RETURN -1

:

CREATE FUNCTION dbo.fun(@v varchar(10))
RETURNS INT
AS
RETURN 1