Base De Datos
GO
use COMERCIAL
create table CLIENTE
(
cod_cli char(5)primary key,
nombre varchar (30),
apellido varchar (30),
edad varchar (2),
DNI varchar (10)
)
createtable PROVEEDOR
(
cod_prov char (5)primary key,
RUC varchar (30),
nombre varchar (30),
correo varchar (30),
telefono varchar (10),
DNI varchar (10)
)
ALTER table CLIENTE add tele_clivarchar(10)
ALTER table PROVEEDOR add direcc_cli varchar (50)
insert into CLIENTE values ('b001','segundo diego','valdera jacinto','18','12548759','2912927')
insert into CLIENTE values ('b002','joselinares','santos casas','20','12545698','2912922')
insert into CLIENTE values ('b003','henrry','sanchez linares','22','51257859','2911527')
insert into CLIENTE values ('b004','selene maria','villanuevavila','19','12564585','2912487')
insert into CLIENTE values ('b005','rocio maria','cornetero mimbela','19','45847885','2912927')
insert into CLIENTE values ('b006','eduardo','cornejogonzales','20','51652654','2914427')
insert into CLIENTE values ('b007','rosa','gonzales gonzales','25','88558989','2965927')
select * from CLIENTE
select * from CLIENTE where (edad>=20)
select * from CLIENTEwhere left (nombre,1)='r'
select cod_cli,nombre,apellido from CLIENTE
select * from CLIENTE ORDER BY apellido desc
insert into PROVEEDOR values ('p001','214522669874','humbertonicolas','nicolas_jacinto@hotmail.com','2912432','12546589','villa maria')
insert into PROVEEDOR values ('p002','214545125674','roda tejada','rosa_tejada@hotmail.com','2911532','21326545','villa el salvador')insert into PROVEEDOR values ('p003','214522669874','jack nicols','jack_nicols@hotmail.com','2945432','87455965','villa maria')
insert into PROVEEDOR values ('p004','221542069874','frankbill','frank_bill@hotmail.com','2918932','21215154','miraflores')
insert into PROVEEDOR values ('p005','214021249874','jhon hall','jhon_hall@hotmail.com','2955432','87988985','tablada')
insert into PROVEEDOR...
Regístrate para leer el documento completo.