SP_Insert_Order_2

CREATE PROCEDURE [dbo].[insert_order_2]
    @ShipperID uniqueidentifier,
    @PaymentTypeID uniqueidentifier,
    @CustEmail nvarchar(MAX),
    @DeliveryNotes nvarchar(MAX),
    @CustID uniqueidentifier
AS
BEGIN
    UPDATE Orders
    SET ShipperID = @ShipperID,
        PaymentTypeID = @PaymentTypeID,
        CustEmail = @CustEmail,
        DeliveryNotes = @DeliveryNotes
    WHERE CustID = @CustID
END