Base de datos #inventario MS SQL SERVER
Enviado por Helena • 17 de Diciembre de 2018 • 866 Palabras (4 Páginas) • 418 Visitas
...
select *from TBL_VENDEDOR
insert into TBL_COBRADOR (COBRAR,NOMBRE_COBRADOR) VALUES(’IDC001’,’RENE AMILCAR’);
insert into TBL_COBRADOR (COBRAR,NOMBRE_COBRADOR) VALUES(’IDC002’,’RENE DURAN’);
insert into TBL_COBRADOR (COBRAR,NOMBRE_COBRADOR) VALUES(’IDC003’,’LETICIA AMILCAR’);
insert into TBL_COBRADOR (COBRAR,NOMBRE_COBRADOR) VALUES(’IDC004’,’JUANA AMILCAR’);
INSERT INTO TBL_ARTICULO VALUES (’ida001’,’SILLA DE SALA’,15)
INSERT INTO TBL_ARTICULO VALUES (’ida002’,’MESA DE SALA’,30)
INSERT INTO TBL_ARTICULO VALUES (’ida003’,’PELOTA DE FUTBOL’,1)
INSERT INTO TBL_ARTICULO VALUES (’ida004’,’SILLA DE JARDIN’,5)
INSERT INTO TBL_ARTICULO VALUES (’ida005’,’CAMISA PARA HOMBRE’,0.5)
INSERT INTO TBL_ARTICULO VALUES (’ida006’,’PUERTA STANDAR’,100)
INSERT INTO TBL_ARTICULO VALUES (’ida007’,’BITUQUIN DE EMERGENCIA’,30)
INSERT INTO TBL_BODEGA(BODEGA,LINEA,NOMBRE_BODEGA,EXISTENCIA) VALUES (’IDB001’,’l0001’,’BODEGA lourdes’,50000)
INSERT INTO TBL_BODEGA(BODEGA,LINEA,NOMBRE_BODEGA,EXISTENCIA) VALUES (’IDB002’,’l0002’,’BODEGA mejicanos’,60000)
INSERT INTO TBL_BODEGA(BODEGA,LINEA,NOMBRE_BODEGA,EXISTENCIA) VALUES (’IDB003’,’l0001’,’BODEGA soyapango’,3000)
INSERT INTO TBL_BODEGA(BODEGA,LINEA,NOMBRE_BODEGA,EXISTENCIA) VALUES (’IDB004’,’l0002’,’BODEGA apopa’,10000)
INSERT INTO TBL_BODEGA(BODEGA,LINEA,NOMBRE_BODEGA,EXISTENCIA) VALUES (’IDB005’,’l0002’,’BODEGA apopa’,10000)
INSERT INTO TBL_BODEGA(BODEGA,LINEA,NOMBRE_BODEGA,EXISTENCIA) VALUES (’IDB006’,’l0010’,’BODEGA lourdes’,50000)
INSERT INTO TBL_BODEGA(BODEGA,LINEA,NOMBRE_BODEGA,EXISTENCIA) VALUES (’IDB007’,’l0011’,’BODEGA mejicanos’,60000)
INSERT INTO TBL_BODEGA(BODEGA,LINEA,NOMBRE_BODEGA,EXISTENCIA) VALUES (’IDB008’,’l0012’,’BODEGA soyapango’,3000)
INSERT INTO TBL_BODEGA(BODEGA,LINEA,NOMBRE_BODEGA,EXISTENCIA) VALUES (’IDB009’,’l0013’,’BODEGA apopa’,10000)
INSERT INTO TBL_BODEGA(BODEGA,LINEA,NOMBRE_BODEGA,EXISTENCIA) VALUES (’IDB010’,’l0014’,’BODEGA apopa’,10000)
insert into TBL_ARTICULO_BODEGA(BODEGA,ARTICULO) values (’IDB001’,’ida001’)
insert into TBL_ARTICULO_BODEGA(BODEGA,ARTICULO) values (’IDB001’,’ida003’)
insert into TBL_ARTICULO_BODEGA(BODEGA,ARTICULO) values (’IDB001’,’ida004’)
insert into TBL_ARTICULO_BODEGA(BODEGA,ARTICULO) values (’IDB002’,’ida001’)
insert into TBL_ARTICULO_BODEGA(BODEGA,ARTICULO) values (’IDB002’,’ida003’)
insert into TBL_ARTICULO_BODEGA(BODEGA,ARTICULO) values (’IDB002’,’ida002’)
insert into TBL_ARTICULO_BODEGA(BODEGA,ARTICULO) values (’IDB003’,’ida001’)
insert into TBL_ARTICULO_BODEGA(BODEGA,ARTICULO) values (’IDB003’,’ida003’)
insert into TBL_ARTICULO_BODEGA(BODEGA,ARTICULO) values (’IDB003’,’ida002’)
insert into TBL_ARTICULO_BODEGA(BODEGA,ARTICULO) values (’IDB004’,’ida004’)
insert into TBL_ARTICULO_BODEGA(BODEGA,ARTICULO) values (’IDB004’,’ida003’)
insert into TBL_ARTICULO_BODEGA(BODEGA,ARTICULO) values (’IDB004’,’ida002’)
select *from TBL_ARTICULO_BODEGA
insert into TBL_FACTURA values(’a’,’n0021’,’idv001’,’idc002’,3,NULL,13,’2014/10/13’,10,10,100,NULL,NULL,’2014/10/13’,’2014/10/13’,NULL)
insert into TBL_FACTURA values(’b’,’n0022’,’idv002’,’idc003’,3,NULL,10,’2014/3/20’,10,10,100,NULL,NULL,’2014/3/12’,’2014/3/20’,NULL)
insert into TBL_FACTURA values(’c’,’n0023’,’idv003’,’idc001’,3,NULL,5,’2014/5/23’,10,10,100,NULL,NULL,’2014/5/23’,’2014/5/23’,NULL)
insert into TBL_FACTURA values(’d’,’n0024’,’idv002’,’idc002’,3,NULL,13,’2014/10/13’,10,10,100,NULL,NULL,’2014/11/13’,’2014/11/13’,NULL)
insert into TBL_FACTURA values(’e’,’n0025’,’idv001’,’idc003’,3,NULL,13,’2014/10/13’,10,10,100,NULL,NULL,’2014/6/13’,’2014/6/13’,NULL)
insert into TBL_FACTURA values(’g’,’n0026’,’idv001’,’idc002’,3,NULL,13,’2015/10/13’,10,10,100,NULL,NULL,’2015/10/13’,’2015/10/13’,NULL)
insert into TBL_FACTURA values(’h’,’n0027’,’idv002’,’idc004’,3,NULL,10,’2015/3/20’,10,10,100,NULL,NULL,’2015/3/12’,’2015/3/20’,NULL)
insert into TBL_FACTURA values(’i’,’n0028’,’idv004’,’idc001’,3,NULL,5,’2015/5/23’,10,10,100,NULL,NULL,’2015/5/23’,’2015/5/23’,NULL)
insert into TBL_FACTURA values(’j’,’n0029’,’idv002’,’idc004’,3,NULL,13,’2015/10/13’,10,10,100,NULL,NULL,’2015/11/13’,’2015/11/13’,NULL)
insert into TBL_FACTURA values(’k’,’n0030’,’idv004’,’idc003’,3,NULL,13,’2015/10/13’,10,10,100,NULL,NULL,’2015/6/13’,’2015/6/13’,NULL)
insert into TBL_FACTURA values(’l’,’n0031’,’idv004’,’idc003’,3,NULL,13,’2016/10/13’,10,10,100,NULL,NULL,’2016/10/13’,’2016/10/13’,NULL)
insert into TBL_FACTURA values(’m’,’n0032’,’idv003’,’idc004’,3,NULL,10,’2016/3/20’,10,10,100,NULL,NULL,’2016/3/12’,’2016/3/20’,NULL)
insert into TBL_FACTURA values(’n’,’n0033’,’idv004’,’idc004’,3,NULL,5,’2016/5/23’,10,10,100,NULL,NULL,’2016/5/23’,’2016/5/23’,NULL)
insert into TBL_FACTURA values(’o’,’n0034’,’idv002’,’idc002’,3,NULL,13,’2016/10/13’,10,10,100,NULL,NULL,’2016/11/13’,’2016/11/13’,NULL)
...