Tugas Ku Perintah Update

1 use dbretail

update tbsatuan
set keterangan='EA'
where keterangan='ea'

2 use dbretail
update tbsatuan
set keterangan='Unit'
where id='8'



3 use dbretail
update tbsatuan
set keterangan='Karung'
where id='9'



4 use dbretail
update tbbarang
set namabarang='Shampo', id='4'
where id='5'



5 use dbretail
update tbbarang
set hjual='5000'
where namabarang='sabun'




6 use dbretail
update tbbarang
set idsatuan='10'
where namabarang='sepatu'

7 use dbretail
update tbbarang
set namabarang='Rinso', status='A'
where id='6'



8 use dbretail
update tbbarang
set idsatuan='4'
where id='6'

9 use dbretail
update tbbarang
set idsatuan='12'
where id='8'


10 UPDATE dbretail.dbo.tbsatuan
  SET keterangan = 'Sachet'
WHERE keterangan ='saset'
GO