Use Northwind database and base your stored procedure off the columns found in the Customer table.

Write a stored procedure named, CustRegion, that accepts a Region as a parameter. The stored proc is to return only the CustomerID, CompanyName, and the Region. Write it so that it can return those rows where the region is a NULL value as well as allowing the user to submit via the parameter a region name such as BC, SP, OR, DF, Isle of Wight, etc. Note: you must test for a NULL value using the IS NULL statement and can't code a Where clause using an '= NULL' as that is not correct and will result in no rows being returned.