DF193: Procedure body is not enclosed in BEGIN…END block.

Last modified: December 25, 2024

The topic describes the DF193 T-SQL code analysis rule.

Category

BEST PRACTICE

Message

Procedure body is not enclosed in BEGIN…END block.

Description

To improve code readability and minimize potential errors, it is recommended to always enclose a stored procedure in the BEGIN…END block.

Noncompliant code example

CREATE PROCEDURE dbo.DemoTable
AS
   SET NOCOUNT ON;
   SELECT id FROM dbo.DemoTable;
GO

Compliant solution

CREATE PROCEDURE dbo.DemoTable
AS
BEGIN
   SET NOCOUNT ON;
   SELECT id FROM dbo.DemoTable;
END
GO