Tabla De Hechos
Enviado por vansk8 • 3 de Diciembre de 2012 • 409 Palabras (2 Páginas) • 456 Visitas
select TOP 1000 [cod_distrito],
[nom_distrito]
from [Inteligencia].[dbo].[tb_distrito]
*********************************************************
select TOP 1000 [num_papeleta],
[entidad],
[fecha],
[hora],
[cod_distrito],
[lugar],
[cod_infractor],
[num_placa],
[Importe],
[estado_papeleta],
[NroCIP_poli]
from [Inteligencia].[dbo].[tb_papeletaconductor]
*********************************************************
select TOP 1000 [num_placa],
[cod_marca],
[cod_modelo],
[color],
[año_fabric],
[tarj_prop],
[cod_propietario],
[cod_aseguradora],
[nro_soat],
[cod_tipovehiculo]
from [Inteligencia].[dbo].[tb_vehiculo]
*********************************************************
select TOP 1000 [cod_infrac],
[cod_gradoinfrac],
[desc_infrac],
[multa],
from [Inteligencia].[dbo].[tb_Infraccion]
*********************************************************
select TOP 1000 [cod_conductor],
[cod_tipodocu],
[nro_tipodocu],
[licconducir_conductor],
[cod_categoriaconductor],
[nom_conductor],
[apepat_conductor],
[apemat_conductor],
[sexo_conductor],
[fecnac_conductor]
[codgrado_intruccion]
from
...