Stored Procedure (GetCustomerOrders)

StoredProcedureGetCustomerOrders.sql

CREATE PROCEDURE [dbo].[sp_get_customer_orders]
(
     @CustomerId INT
)
AS
BEGIN
     SELECT *
     FROM [dbo].[Orders]
     WHERE (CustomerId = @CustomerId)
     ORDER BY OrderDateUtc ASC;
END