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) |
|