Ingresar de datos en la base de datos
Forma Manual
1.Ya creado las tablas.
2. Click derecho sobre la tabla que se desee editar, en "Edit Top 200 Rows" .
Nos muestra de forma grafica y se guarda automaticamente.
Mediante Código
/**************************************************************************
CONSULTA DE OBJETOS EN LA BASE DE DATOS HELADERIA
En este script se muestran los comandos para la insercion de datos por medio
por medio de codigo
Autor: Stephania Perez y curso
Fecha: 11/11/2014
*************************************************************************/
--//////Tabla TipoHelado ('Codigo',Nombre','Descripcion','Usuario')//////
use Heladeria1
go
insert into TipoHelado
values ('01','Crema','Esta compuesto de crema','JPonce')
GO
insert into TipoHelado
values('02', 'Hielo','Esta hecho de agua con sabor','DMejia')
GO
insert into TipoHelado
values('03', 'Sorbete','Esta compuesto de sumo de frutas','MCuñas')
GO
insert into TipoHelado
values ('04','Paila','Esta compuesto de pulpa de fruta','KPucci')
GO
insert into TipoHelado
values('05', 'vasito','Esta compuesto de crema','JBuitron')
go
insert into TipoHelado
values('06', 'Cono','Esta compuesto de crema','CVaca')
go
insert into TipoHelado
values ('07','Barquillo','Esta compuesto de leche evaporada','RChiriboga')
GO
insert into TipoHelado
values ('08','Mantecado','Esta compuesto de crema ','BBenavides')
GO
insert into TipoHelado
values ('09', 'Natilla', 'Está compuesto de yema de huevo y 10% de grasa láctea', 'PDarquea')
GO
insert into TipoHelado
values ('10', 'granizado', 'Es un helado de agua semisolido', 'DFlores')
GO
insert into TipoHelado
values ('11', 'copa', 'Está compuesto crema y el sabor a peticion', 'LPilco')
GO
insert into TipoHelado
values ('12', 'Tulipan', 'Esta compuesto por el helado dentro de una galleta','CLopez')
GO
insert into TipoHelado
values ('13', 'Gelato', ' Este helado es más denso con más crema y edulcorantes. ','SCueva')
GO
insert into TipoHelado
values ('14', 'Caseras', 'Helado de crema con sabor a flan y con relleno de dulce de leche', 'SPerez')
GO
insert into TipoHelado
values('15','Sherbets','Contiene menor porcentaje de grasa y mayor en edulcorantes.','MTaco')
GO
insert into TipoHelado
values('16','Paila', 'Helado de crema con sabor a Mora' ,'EPazmiño')
GO
--///////Tabla Sabor ('Codigo',Nombre','Usuario') //////////////
insert into Sabor
values ('01','Vainilla','JPonce')
GO
insert into Sabor
values('02','Chocolate',' DMejia')
GO
insert into Sabor
values('03','Mora',' JRoman')
GO
insert into Sabor
values('04','Maracuya',' CVaca')
GO
insert into Sabor
values('05','Naranja',' MCuñas')
GO
insert into Sabor
values('06','Coco',' Kpucci')
GO
insert into Sabor
values('07','Mango','JBuitron')
GO
insert into Sabor
values ('08','Fresa','RChiriboga')
GO
insert into Sabor
values('09','Limón',' BBenavides')
GO
insert into Sabor
values('10', 'Kiwi', 'PDarquea')
GO
insert into Sabor
values ('11','Tamarindo ','DFlores')
GO
insert into Sabor
values ('12','Ron pasas ','LPilco')
GO
insert into Sabor
values ('13','Frutas naturales ','JAngo')
GO
insert into Sabor
values ('14','Piña ','JAngo')
GO
insert into Sabor
values ('15','leche ','JAngo')
GO
insert into Sabor
values ('16','Avellana ','JDavila')
GO
insert into Sabor
values ('17','Pistacho','CLopez')
GO
insert into Sabor
values ('18','Limon','SCueva')
GO
insert into Sabor
values('19','Flan', 'SPerez')
Go
insert into Sabor
values ('20','Chicle','DVillamil')
GO
insert into Sabor
values('21','Frambuesa','MTaco')
GO
insert into Sabor
values('22','Banana','EPazmiño')
GO
insert into Sabor
values('23','Mandarina','NYanez')
GO
-- ////////Tabla Sector values ('Codigo','Nombre','Referencia','Observaciones','Usuario')
insert into Sector
values ('01','El condado','Norte',null,'JPonce')
GO
insert into Sector
values('02','Cotocollao','Norte',null,'DMejia')
GO
insert into Sector
values('03','El Inca','Norte',null,'JRoman')
GO
insert into Sector
values('04','Recoleta','Centro',null,'CVaca')
GO
insert into Sector
values('05','El Dorado','Sur',null,'MCuñas')
GO
insert into Sector
values('06','La Floresta','Centro',null,'KPucci')
GO
insert into Sector
values('07','La Vicentina','Centro',null,'JBuitron')
GO
insert into Sector
values ('08','Calderon','Norte',null,'RChiriboga')
GO
insert into Sector
values ('09','Carcelen',null,null,'PDarquea')
GO
insert into Sector
values ('10','La armenia','Valle',null,'DFlores')
GO
insert into Sector
values ('11','San carlos','Norte','en el parque ingles','LPilco')
GO
insert into Sector
values ('12','Tumbaco','NorOriente','Parque central tumbaco','JAngo')
GO
insert into Sector
values ('13','La Madgalena','Sur','Mercado La Madgalena','SCueva')
GO
insert into Sector
values ('14','Pimampiro', 'Imbabura', null, 'CLopez')
GO
insert into Sector
values('15','Marianas', 'Norte', null, 'SPerez' )
GO
insert into Sector
values('16','La Luz', 'Norte', null, 'DVillamil' )
GO
insert into Sector
values('17','El Calzado','Sur','Parque el Calzado','MTaco')
insert into Sector
values('18','Condado Bajo', 'Norte', null, 'EPazmiño' )
GO
insert into Sector
values('19','Mitad del mundo', 'Norte', null, 'NYanez' )
GO
--////////Tabla Helado ('Codigo','Codigo_TipoHelado','Usuario','Nombre','Precio','Costo')
insert into Helado
values ('01','02','Gemelo','JPonce',0.75,0.55)
GO
insert into Helado
values('02','01','Corneto','DMejia',1.00,0.80)
GO
---------------------------------------------------------------------------------------------------------------------------
insert into Helado
values('03','01','Sanduche','JRoman',0.80,0.60)
GO
insert into Helado
values('04','02','Frutare','CVaca',0.85,0.65)
GO
insert into Helado
values('05','01','Polito','MCuñas',0.90,0.70)
GO
insert into Helado
values('06','01','Casero','KPucci',0.75,0.55)
GO
insert into Helado
values('07','02','Vasito','JBuitron',0.75,0.60)
GO
insert into Helado
values('08','01','Empastado','RChiriboga',0.70,0.55)
GO
insert into Helado
values ('09','06','Magnum','PDarquea',1.00,0.75)
GO
insert into Helado
values ('10','09','Acidix','DFlores',0.35,0.25)
GO
insert into Helado
values ('11','04','Pailon','LPilco',0.85,0.55)
GO
insert into Helado
values ('12','04','Futbolin','JAngo',0.55,0.25)
GO
insert into Helado
values ('13','06','Artesanal','JDavila',1.00,0.90)
GO
insert into Helado
values ('14','04','Manicho','CLopez',1.00,0.80)
insert into Helado
values ('15','15','Neve','SCueva',1.00,0.90)
GO
insert into Helado
values('16','01','Caseras','SPerez',1.50,1.30)
GO
insert into Helado
values('17','01','Haagen Dazs','DVillamil',3.50,2.80)
GO
insert into Helado
values('18','11','Copa Tropical','MTaco',1.25,1.00)
insert into Helado
values('19','13','Cotopaxi','Epazmino',2.00,1.90)
GO
insert into Helado
values('20','01','Romano','NYanez',1.20,1.20)
GO
-- ////////Tabla SaborHelado (porcentaje,CodigoSabor,CodigoHelado,'Usuario')
-----------------------------------------------------------------------------------------------------------------------------------------------------------
insert into SaborHelado
values ('20','02','02','JPonce')
GO
insert into SaborHelado
values('40','01','02','DMejia')
GO
insert into SaborHelado
values('60','03','03','JRoman')
GO
insert into SaborHelado
values('21','04','02','CVaca')
GO
insert into SaborHelado
values('30','02','03','MCuñas')
GO
insert into SaborHelado
values('90','02','06','KPucci')
GO
insert into SaborHelado
values('80','05','07','JBuitron')
GO
insert into SaborHelado
values('50','03','04','RChiriboga')
GO
insert into SaborHelado
values ('65','08','10','PDarquea')
GO
insert into SaborHelado
values ('75','09','10','DFlores')
GO
insert into SaborHelado
values ('41','12','08','LPilco')
GO
insert into SaborHelado
values ('55','11','09','JAngo')
GO
insert into SaborHelado
values ('92','16','13','JDavila')
GO
insert into SaborHelado
values ('91','18','15','SCueva')
GO
insert into SaborHelado
values('33','19','16','SPerez')
GO
insert into SaborHelado
values ('70','22','19','EPazmiño')
GO
insert into SaborHelado
values ('61','13','18','MTaco')
go
insert into SaborHelado
values ('10','01','20','NYanez')
go
--/////////Tabla Heladero ('Cedula','Codigo_Sector','Nombre','Apellido','Direccion','Telefono','Usuario')
insert into Heladero
values ('1716729015','01','Juan','Ponce','Cale V','0984937392','JPonce')
GO
insert into Heladero
values ('1723455676','02','Diego','Mejia','Calle SN','0223456774','DMejia')
GO
insert into Heladero
values ('1721482253','03','Juan','Roman','Calle N', '0923456667', 'JRoman')
go
insert into Heladero
values ('1714430152','04','Coraima','Vaca','Calle Maldonado','0998335329','CVaca')
GO
insert into Heladero
values ('1710991547','05','Mishell','Cuñas','Calle Angel Rojas','0983333081','MCuñas')
GO
insert into Heladero
values ('1718719006','06','Karen','Pucci','Avenida de los Granados','0994925423','KPucci')
GO
insert into Heladero
values('1714838743','07','Jesley','Buitron','Marcelo Rivadeneira','0992501098','JBuitron')
GO
insert into Heladero
values ('1718161927','08','Rodrigo','Chiriboga','Ramon Ignacio','0223456774','RChiriboga')
GO
insert into Heladero
values('1715578521','09','Bryan','Benavides','Calle Vicente León','0995643123','BBenavides')
GO
insert into Heladero
values ('1716389117','10','Diego','Flores','Av. Manuela Cañizares','0995071925','DFlores')
GO
insert into Heladero
values ('6039439947','11','Luis','Pilco','Calle Machala','0979323343','LPilco')
GO
insert into Heladero
values ('1723781071','12','Jhony','Ango','Calle francisco de orellana','0995045550','JAngo')
GO
insert into Heladero
values ('1775932754','13','Paulo','Darquea','Av. Diego de Vásquez','0992874901','PDarquea')
GO
insert into Heladero
values ('1722946629','14','Andre','Villamil','Roberto Paez','0996506653','DVillamil')
GO
insert into Heladero
values ('1750654698','15','Juan','Dávila','Higuerillas','0987871188','JDavila')
GO
insert into Heladero
values ('1724406303','16','Cristian','Lopez', 'Av. Rumipamba', '0999278202', 'CLopez')
GO
insert into Heladero
values ('1721512373','17','Sebastian','Cueva','Av. Hualcopo','098902583','SCueva')
GO
insert into Heladero
values ('1718364749', '18','Stephania','Perez','Calle Cristo del Consuelo','0993373409','SPerez')
GO
insert into Heladero
values ('1722045430', '19','Erick','Pazmiño','Calle Machala','0997929392','EPazmiño')
GO
insert into Heladero
values('1750210724','17','Marco','Taco','AV. Cardenal de la Torre','022627882','MTaco')
GO
--//////Tabla Venta ( ID, CodigoHeladero, fecha, Total, Usuario')
insert into Venta
values ('01','1716729015','2014-01-31',200.50,'JPonce')
GO
insert into Venta
values('02','1723455676','2014-10-31',24.45,'DMejia')
GO
insert into Venta
values('03','1721482253','2014-03-29',100.20,'JRoman')
GO
insert into Venta
values('04','1714430152','2014-03-28',80.50,'CVaca')
GO
insert into Venta
values('05','1710991547','2014-03-27',58.40,'MCuñas')
GO
insert into Venta
values('06','1718719006','2014-03-30',56.00,'KPucci')
GO
insert into Venta
values('07','1714838743','2014-03-12',90.75,'JBuitron')
GO
insert into Venta
values('08','1723781071','2014-10-22',123.98,'DMejia')
GO
insert into Venta
values('09','1718161927','2014-11-14',70.30,'RChiriboga')
GO
insert into Venta
values('10', '1715578521','2014-11-20', 88.50, 'BBenavides')
GO
insert into Venta
values ('11','1718161927','2014-04-10',12.24,'PDarquea')
GO
insert into Venta
values ('12','1716389117','2014-10-02',104.25,'DFlores')
GO
insert into Venta
values ('13','1721482253','2014-10-11',100.20,'JAngo')
GO
insert into Venta
values ('15','1714838743','2014-10-12',38.80,'DVillamil')
GO
insert into Venta
values ('16','1718161927','2014-10-13',30.00,'RGarces')
GO
insert into Venta
values ('17','6039439947','2014-10-14',42.75,'LPilco')
GO
insert into Venta
values ('18','1723455676','2014-10-15',48.50,'RGarces')
GO
insert into Venta
values ('19','1750654698','2014-01-01',10.00,'JDavila')
GO
insert into Venta
values ('20','1724406303','2014-10-01',25.00,'CLopez')
GO
insert into Venta
values ('21','1721512373','2014-07-07',49.00,'SCueva')
GO
insert into Venta
values ('22','1718364749','2014-05-06',33.50,'SPerez')
GO
insert into Venta
values ('23','1722045430','2014-08-09',15.00,'EPazmiño')
GO
insert into Venta
values ('24','1750210724','2014-07-05',45.50,'MTaco')
GO
insert into Venta
values ('25','1750654698','2014-11-06',18.00,'MMedina')
GO
--/////// Tabla DetalleVenta (Id, CodigoVenta, CodigoHelado, Cantidad, Usuario')
insert into DetalleVenta
values ('01','01','01','20','JPonce')
GO
insert into DetalleVenta
values ('02','01','01','10','JPonce')
GO
insert into DetalleVenta
values ('03','01','01','15','JPonce')
GO
insert into DetalleVenta
values ('04','02','02','20','DMejia')
GO
insert into DetalleVenta
values ('05','03','03','10','JRoman')
GO
insert into DetalleVenta
values ('06','02','04','5','JRoman')
GO
insert into DetalleVenta
values ('07','01','03','20','JRoman')
GO
insert into DetalleVenta
values ('08','03','04','10','CVaca')
GO
insert into DetalleVenta
values ('09','03','03','15','CVaca')
GO
insert into DetalleVenta
values ('10','01','05','8','CVaca')
GO
insert into DetalleVenta
values ('11','05','05','6','MCuñas')
GO
insert into DetalleVenta
values ('12','05','05','40','MCuñas')
GO
insert into DetalleVenta
values ('13','05','04','20','MCuñas')
GO
insert into DetalleVenta
values('14','07','06','4','JBuitron')
GO
insert into DetalleVenta
values('15','07','07','3','JBuitron')
GO
insert into DetalleVenta
values('16','07','08','5','JBuitron')
GO
insert into DetalleVenta
values('17','06','05','20','DMejia')
GO
insert into DetalleVenta
values('18','03','05','16','DMejia')
GO
insert into DetalleVenta
values ('19','08','07','5','RChiriboga')
GO
insert into DetalleVenta
values ('20','08','06','20','RChiriboga')
GO
insert into DetalleVenta
values ('21','09','07','10','RChiriboga')
GO
insert into DetalleVenta
values('22','09','03','25','DVillamil')
GO
insert into DetalleVenta
values('23','04','02','16','DVillamil')
GO
insert into DetalleVenta
values('24','04','08','4','DVillamil')
GO
insert into DetalleVenta
values ('25','05','10','10','PDarquea')
GO
insert into DetalleVenta
values ('26','08','01','17','PDarquea')
GO
insert into DetalleVenta
values ('27','03','06','19','PDarquea')
GO
insert into DetalleVenta
values ('28','12','10','18','DFlores')
GO
insert into DetalleVenta
values ('29','12','10','21','DFlores')
GO
insert into DetalleVenta
values ('30','12','10','20','DFlores')
GO
insert into DetalleVenta
values ('31','06','02','20','KPucci')
GO
insert into DetalleVenta
values ('32','06','06','20','KPucci')
GO
insert into DetalleVenta
values ('33','06','06','10','KPucci')
GO
insert into DetalleVenta
values ('34','17','11','15','LPilco')
GO
insert into DetalleVenta
values ('35','17','01','20','LPilco')
GO
insert into DetalleVenta
values ('36','17','02','15','LPilco')
GO
insert into DetalleVenta
values ('37','03','01','12','JAngo')
GO
insert into DetalleVenta
values ('38','03','01','15','JAngo')
GO
insert into DetalleVenta
values ('39','03','01','16','JAngo')
GO
insert into DetalleVenta
values ('40','16','09','15','RGarces')
GO
insert into DetalleVenta
values ('41','16','03','10','RGarces')
GO
insert into DetalleVenta
values ('42','16','10','20','RGarces')
GO
insert into DetalleVenta
values ('43','18','02','15','RGarces')
GO
insert into DetalleVenta
values ('44','18','04','10','RGarces')
GO
insert into DetalleVenta
values ('45','18','13','25','RGarces')
GO
insert into DetalleVenta
values ('46','19','13','5','JDavila')
GO
insert into DetalleVenta
values ('47','19','13','5','JDavila')
GO
insert into DetalleVenta
values ('48','20','14','10','CLopez')
GO
insert into DetalleVenta
values ('49','20','14','25','CLopez')
GO
insert into DetalleVenta
values ('50','20','14','12','CLopez')
GO
insert into DetalleVenta
values ('51','21','15','11','SCueva')
GO
insert into DetalleVenta
values ('52','21','15','18','SCueva')
GO
insert into DetalleVenta
values ('53','21','15','20','SCueva')
GO
insert into DetalleVenta
values('54','22','16','10','SPerez')
GO
insert into DetalleVenta
values('55','22','02','10','SPerez')
GO
insert into DetalleVenta
values('56','22','04','10','SPerez')
GO
insert into DetalleVenta
values ('57','23','19','08','EPazmiño')
GO
insert into DetalleVenta
values ('58','23','19','12','EPazmiño')
GO
insert into DetalleVenta
values ('59','23','19','15','EPazmiño')
GO
insert into DetalleVenta
values('60','18','06','20','MTaco')
GO
insert into DetalleVenta
values('61','17','05','15','MTaco')
GO
insert into DetalleVenta
values('62','13','09','25','MTaco')
GO
insert into DetalleVenta
values('63','25','11','02','MMedina')
GO
insert into DetalleVenta
values('64','02','16','10','MMedina')
GO
insert into DetalleVenta
values('65','07','08','08','MMedina')
GO