ALTER PROCEDURE SelectContactByRegion @Region nvarchar(15) AS
  BEGIN -- (1)
    IF @Region is NULL
      BEGIN -- (2)

        PRINT 'PARAMETER IS NULL'

        SELECT CustomerID, CompanyName, ContactName, Phone
        FROM Customers
        WHERE Region is NULL

      END -- (2)
    ELSE
      BEGIN -- (3)

        PRINT 'PARAMETER IS ' + @Region

        SELECT CustomerID, CompanyName, ContactName, Phone
        FROM Customers
        WHERE Region = @Region

      END -- (3)
  END -- (1)
例4のリスト(テキスト版

ALTER PROCEDURE SelectContactByRegion @Region nvarchar(15) AS
  BEGIN -- (1)
    IF @Region is NULL
      BEGIN -- (2)

        PRINT 'PARAMETER IS NULL'

ALTER PROCEDURE SelectContactByRegion @Region nvarchar(15) AS
  BEGIN -- (1)
    IF @Region is NULL
      BEGIN -- (2)

        PRINT 'PARAMETER IS NULL'

        SELECT CustomerID, CompanyName, ContactName, Phone
        FROM Customers
        WHERE Region is NULL

      END -- (2)
    ELSE IF (SELECT COUNT(*) FROM Customers WHERE Region = @Region) > 0
      BEGIN -- (3)

        PRINT 'PARAMETER IS ' + @Region

        SELECT CustomerID, CompanyName, ContactName, Phone
        FROM Customers
        WHERE Region = @Region

      END -- (3)
    ELSE
      BEGIN -- (4)

        PRINT 'ERROR: REGION IS NOT EXIST'

      END -- (4)

  END -- (1)
例5のリスト(テキスト版