Tugas Ku Perintah Insert

1 use dbretail

insert into tbbarang
values('sabun','4','50',2000,2500,'A')


2 insert into dbretail.dbo.tbbarang
(namabarang,idsatuan,jumlah,hbeli,hjual,status)
values('sabun','4','50',2000,2500,'A')




3 insert into dbretail.dbo.tbbarang
(namabarang,idsatuan,jumlah,hbeli,hjual,status)
values('rinso','9','100',5000,5500,'T')




4 insert into dbretail.dbo.tbbarang
(namabarang,idsatuan,jumlah,hbeli,hjual,status)
values('sandal jepit','5','15',7000,7500,'A')




5 use dbretail

insert into tbbarang (namabarang,idsatuan,jumlah,hbeli,hjual,status)
values('tusuk sate','4','50',2000,2500,'A'),
('Sunlight','9','100',5000,5500,'A'),
('Minyak Gas','5','15',7000,7500,'A'),
('Celana','3','30',70000,80000,'A');

6 insert into dbretail.dbo.tbsatuan
(keterangan)
values('pasang')


7 insert into dbretail.dbo.tbsatuan
(keterangan)
values('BOX')


8 insert into dbretail.dbo.tbsatuan
(keterangan)
values('Lusin')


9 insert into dbretail.dbo.tbsatuan
(keterangan)
values('Kodi')



10 insert into dbretail.dbo.tbsatuan
(keterangan)
values('Batang')