Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 3 create procedure spPilihPesananRideJekc(@IDRide varchar(2), @IDDrive nvarchar(9))
- as begin
- update Ridejek
- set ID_Status = '002', No_Registrasi = @IDDrive
- where ID_Ridejek = @IDRide
- end
- 6.create procedure spSelesaiMengantarPenumpangRideJek(@IDRide varchar(2))
- as begin
- update Ridejek
- set ID_Status = '003'
- where ID_Ridejek = @IDRide
- end
- 13. create procedure spSelesaiAntarBarangSendJek(@IDSend varchar(2))
- as begin
- if( ID_Status ='Diantar' or ID_Status = 'Ditolak')
- update Sendjek
- set ID_Status = '003'
- where ID_Ridejek = @IDRide
- end
- 24. create procedure spTambahSaldoDeposit(@IDDrive nvarchar(9), @jumlah int)
- as begin
- update Driver
- set Saldo += @jumlah
- where No_Registrasi = @IDDrive
- end
- 25. create procedure spTambahMenuBaru(@Nama nvarchar(30), @jenis nvarchar(50), @status nvarchar(20), @harga int, @IDRest nvarchar(3))
- as begin
- insert into Resto
- values (@Nama, @jenis, @status, @harga, @IDRest)
- end
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement