DF193: Procedure body is not enclosed in BEGIN…END block.
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
Want to Find out More?
Overview
Take a quick tour to learn all about the key benefits delivered by dbForge Studio for SQL Server.
All features
Get acquainted with the rich features and capabilities of the Studio in less than 5 minutes.
Request a demo
If you consider employing the Studio for your business, request a demo to see it in action.
Ready to start using dbForge Studio for SQL Server?