CREATE PROCEDURE GetCustomerByPK (@nCustomerPK int) AS SELECT * FROM Customer WHERE CustomerPK = @nCustomerPK GO