CREATE PROCEDURE UpdateBillID
@VoucherID uniqueidentifier,
@BillID int
AS
BEGIN
UPDATE Vouchers SET BillID = @BillID WHERE VoucherID = @VoucherID;
END