Listing 3: Code to Test the Stored Procedure
EXEC dbo.usp_GetOrders @OrderID = 10248;
EXEC dbo.usp_GetOrders @OrderDate = '19970101';
EXEC dbo.usp_GetOrders @CustomerID = N'CENTC';
EXEC dbo.usp_GetOrders @EmployeeID = 5;