Trabajo GESTION DE DATOS E INFORMACION

...

---------------------------------------------------------------

[pic 2][pic 3][pic 4]

[pic 5]

[pic 6][pic 7][pic 8]

[pic 9][pic 10][pic 11]

[pic 12][pic 13][pic 14]

[pic 15][pic 16][pic 17][pic 18]

[pic 19][pic 20][pic 21][pic 22][pic 23][pic 24][pic 25][pic 26][pic 27][pic 28][pic 29][pic 30][pic 31][pic 32][pic 33][pic 34][pic 35]

[pic 36]

INSERT INTO PRODUCTO Values (1, Mantequilla,1.5,50)

INSERT INTO PRODUCTO Values(2, Leche, 5.5,50)

INSERT INTO PRODUCTO Values(2, PH, 1.2,40)

INSERT INTO PRODUCTO Values(2, Atun, 4.6,40)

INSERT INTO CLIENTE Values(1, Miguel,54032827)

INSERT INTO CLIENTE Values(2, Julisa,53722854)

INSERT INTO CLIENTE Values(3, Jose,56080422)

INSERT INTO CLIENTE Values(4, Marcos,57284541)

INSERT INTO PERSONAL Values(097,Juan,05/04/1990,998174769, 09740115)

INSERT INTO PERSONAL Values(713,Pedro,02/01/1987,996251463, 71328452)

INSERT INTO PERSONAL Values(112,Jose,25/04/1992,992147784, 11226478)

INSERT INTO PERSONAL Values(742,Marcos,30/09/1990,996984425, 74258411)

INSERT INTO CATPRODUCTO Values(159,Bebida)

INSERT INTO CATPRODUCTO Values(298,Golosina)

INSERT INTO CATPRODUCTO Values(295,Lacteo)

INSERT INTO CATPRODUCTO Values(147,Vegetal)

INSERT INTO PROVEEDOR Values(897,ProvBebida)

INSERT INTO PROVEEDOR Values(123,ProvGolosina)

INSERT INTO PROVEEDOR Values(456,ProvLacteo)

INSERT INTO PROVEEDOR Values(524,ProvVegetal)

INSERT INTO CATPERSONAL Values(147,Atencion)

INSERT INTO CATPERSONAL Values(258,Limpieza)

INSERT INTO CATPERSONAL Values(369,Seguridad)

INSERT INTO CATPERSONAL Values(197,Almacen)

INSERT INTO DOC_VENTA Values(456,14725836978,Furion,La Molina,30/05/2017)

INSERT INTO DOC_VENTA Values(159,15935748621,Centurion, Cercado de Lima,30/05/2017)

INSERT INTO DOC_VENTA Values(753,14328759614,Star,Comas,30/05/2017)

INSERT INTO DOC_VENTA Values(317,19683259741,Elune,Independencia,30/05/2017)

- Select * from Empleado.Empleado

- Select * from Empleado.Empleado where NameEmpleado = ‘Juan’

- Select * from Empleado.Empleado where NameEmpleado= ‘Juan’ order by ApeEmpleado asc

4) Select top10 * from Empleado Empleado.Empleado

Select distintc EdadEmpleado from Empleado.Empleado

- Select * from Empleado.Empleado where NameEmpleado =’Juan’ and SalaryEmpleado

- Select * from Empleado.Empleado where SalaryEmpleado BETWEEN 100 and 500

- Select * from Empleado.Empleado where NameEmpleado in(‘Juan’,’Pedro’)

- Select * from Empleado.Empleado where PhoneNumber like ‘998%’

- Select lower (NameEmpleado) from Empleado.Empleado

- Select upper (NameEmpleado) from Empleado.Empleado

- Select ltrim(NameEmpleado) from Empleado.Empleado

- Select rtrim(NameEmpleado) from Empleado.Empleado

- Select * from Empleado.Empleado where PhoneNumber SUBSTRING(PhoneNumber,1,3)

- Select round(SalaryEmpleado) from Empleado.Empleado

- Select power(EdadEmpleado,2) from Empleado.Empleado

- Select ABS(SalaryEmpleado) from Empleado.Empleado

- Select Datediff(day,ShipDate,Duedate) from Empleado.Empleado

- Select Datepart(year,Shipdate) from Empleado.Empleado

- Select Getdate() from Empleado.Empleado