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