DF201: Numbered procedure is used.

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

Message

Numbered procedure is used.

Description

Numbered procedures are deprecated and should be avoided.

Noncompliant code example

CREATE PROCEDURE dbo.numbered_procedure;1
AS
BEGIN
    SET NOCOUNT ON
    SELECT id FROM dbo.DemoTable
END
GO
 
CREATE PROCEDURE dbo.numbered_procedure;2
AS
BEGIN
    SET NOCOUNT ON
    SELECT id FROM production.product
END
GO

Compliant solution

CREATE PROCEDURE dbo.numbered_procedure_1
AS
BEGIN
    SET NOCOUNT ON
    SELECT id FROM dbo.DemoTable
END
GO
 
CREATE PROCEDURE dbo.numbered_procedure_2
AS
BEGIN
    SET NOCOUNT ON
    SELECT id FROM production.product
END
GO