Creacion de la tabla
CREATE TABLE [dbo].[Persona](
[IdPersona] [int] NOT NULL,
[PersonaNombre] [varchar](60) NOT NULL,
[PersonaApellido] [varchar](60) NULL,
[FechaNacimiento] [date] NOT NULL,
[CURP] [varchar](13) NULL,
[PersonaDomicilio] [varchar](150) NULL,
CONSTRAINT [PK_Persona] PRIMARY KEY CLUSTERED
(
[IdPersona] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
[IdPersona] [int] NOT NULL,
[PersonaNombre] [varchar](60) NOT NULL,
[PersonaApellido] [varchar](60) NULL,
[FechaNacimiento] [date] NOT NULL,
[CURP] [varchar](13) NULL,
[PersonaDomicilio] [varchar](150) NULL,
CONSTRAINT [PK_Persona] PRIMARY KEY CLUSTERED
(
[IdPersona] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
Insercion de datos
consultas
Funciones Agregadas
Creacion de Vistas
Vista
1
CREATE
VIEW [dbo].[PersonaFecha]
AS
SELECT TOP (100) PERCENT IdPersona, PersonaApellido, FechaNacimiento, PersonaDomicilio
FROM dbo.Persona
ORDER BY PersonaApellido
GO
Vista 2
CREATE
VIEW [dbo].[PersonaCURP]
AS
SELECT PersonaNombre, CURP, PersonaApellido
FROM dbo.Persona
GO
Vista 3
CREATE
VIEW [dbo].[ListaPersona]
AS
SELECT TOP (100) PERCENT IdPersona AS id, PersonaNombre AS nombre, PersonaApellido AS apellido
FROM dbo.Persona
ORDER
BY id
GO
No hay comentarios:
Publicar un comentario