Bienvenidos

Espero que este Blog llene todas las expectativas que estan buscando

Imagen 1

Se denomina inteligencia empresarial, inteligencia de negocios o BI (del inglés business intelligence)

Imagen 2 title

al conjunto de estrategias y herramientas enfocadas a la administración y

Imagen 3 title

creación de conocimiento mediante el análisis de datos existentes en

Imagen 4 title

una organización o empresa.

domingo, 24 de marzo de 2013

SCRIPT BD CURSO

Posted by Elvin German 8:47, under | No comments

USE [master]
GO
/****** Object:  Database [CURSO]    Script Date: 03/24/2013 11:44:10 ******/
CREATE DATABASE [CURSO]
go
use CURSO
go
CREATE TABLE [dbo].[emp1](
    [EMP_NO] [int] NOT NULL,
    [APELLIDO] [varchar](8) NULL,
    [OFICIO] [varchar](10) NULL,
    [DIRECTOR] [int] NULL,
    [FECHA_ALTA] [datetime] NULL,
    [SALARIO] [float] NULL,
    [COMISION] [float] NULL,
    [DEP_NO] [int] NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
INSERT [dbo].[emp1] ([EMP_NO], [APELLIDO], [OFICIO], [DIRECTOR], [FECHA_ALTA], [SALARIO], [COMISION], [DEP_NO]) VALUES (7499, N'alonso', N'VENDEDOR', 7698, CAST(0x000073C600000000 AS DateTime), -1400, 400, 30)
INSERT [dbo].[emp1] ([EMP_NO], [APELLIDO], [OFICIO], [DIRECTOR], [FECHA_ALTA], [SALARIO], [COMISION], [DEP_NO]) VALUES (7521, N'LOPEZ', N'EMPLEADO', 7782, CAST(0x0000741000000000 AS DateTime), 1350.5, NULL, 10)
INSERT [dbo].[emp1] ([EMP_NO], [APELLIDO], [OFICIO], [DIRECTOR], [FECHA_ALTA], [SALARIO], [COMISION], [DEP_NO]) VALUES (7654, N'MARTIN', N'VENDEDOR', 7698, CAST(0x0000749F00000000 AS DateTime), 1500, 1600, 30)
INSERT [dbo].[emp1] ([EMP_NO], [APELLIDO], [OFICIO], [DIRECTOR], [FECHA_ALTA], [SALARIO], [COMISION], [DEP_NO]) VALUES (7698, N'GARRIDO', N'DIRECTOR', 7839, CAST(0x0000740900000000 AS DateTime), 3850.12, NULL, 30)
INSERT [dbo].[emp1] ([EMP_NO], [APELLIDO], [OFICIO], [DIRECTOR], [FECHA_ALTA], [SALARIO], [COMISION], [DEP_NO]) VALUES (7782, N'MARTINEZ', N'DIRECTOR', 7839, CAST(0x0000743000000000 AS DateTime), 2450, NULL, 10)
INSERT [dbo].[emp1] ([EMP_NO], [APELLIDO], [OFICIO], [DIRECTOR], [FECHA_ALTA], [SALARIO], [COMISION], [DEP_NO]) VALUES (7839, N'REY', N'PRESIDENTE', NULL, CAST(0x000074D100000000 AS DateTime), 6000, NULL, 10)
INSERT [dbo].[emp1] ([EMP_NO], [APELLIDO], [OFICIO], [DIRECTOR], [FECHA_ALTA], [SALARIO], [COMISION], [DEP_NO]) VALUES (7844, N'CALVO', N'VENDEDOR', 7698, CAST(0x0000748B00000000 AS DateTime), 1800, 0, 30)
INSERT [dbo].[emp1] ([EMP_NO], [APELLIDO], [OFICIO], [DIRECTOR], [FECHA_ALTA], [SALARIO], [COMISION], [DEP_NO]) VALUES (7876, N'GIL', N'ANALISTA', 7782, CAST(0x0000757B00000000 AS DateTime), 3350, NULL, 20)
INSERT [dbo].[emp1] ([EMP_NO], [APELLIDO], [OFICIO], [DIRECTOR], [FECHA_ALTA], [SALARIO], [COMISION], [DEP_NO]) VALUES (7900, N'JIMENEZ', N'EMPLEADO', 7782, CAST(0x000076BD00000000 AS DateTime), 1400, NULL, 20)
/****** Object:  Table [dbo].[EMP_ROM]    Script Date: 03/24/2013 11:44:10 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[EMP_ROM](
    [EMP_NO] [int] NOT NULL,
    [APELLIDO] [varchar](8) NULL,
    [OFICIO] [varchar](10) NULL,
    [DIRECTOR] [int] NULL,
    [FECHA_ALTA] [datetime] NULL,
    [SALARIO] [float] NULL,
    [COMISION] [float] NULL,
    [DEP_NO] [int] NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
INSERT [dbo].[EMP_ROM] ([EMP_NO], [APELLIDO], [OFICIO], [DIRECTOR], [FECHA_ALTA], [SALARIO], [COMISION], [DEP_NO]) VALUES (7499, N'alonso', N'VENDEDOR', 7698, CAST(0x000073C600000000 AS DateTime), -1400, 400, 30)
INSERT [dbo].[EMP_ROM] ([EMP_NO], [APELLIDO], [OFICIO], [DIRECTOR], [FECHA_ALTA], [SALARIO], [COMISION], [DEP_NO]) VALUES (7521, N'LOPEZ', N'EMPLEADO', 7782, CAST(0x0000741000000000 AS DateTime), 1350.5, NULL, 10)
INSERT [dbo].[EMP_ROM] ([EMP_NO], [APELLIDO], [OFICIO], [DIRECTOR], [FECHA_ALTA], [SALARIO], [COMISION], [DEP_NO]) VALUES (7654, N'MARTIN', N'VENDEDOR', 7698, CAST(0x0000749F00000000 AS DateTime), 1500, 1600, 30)
INSERT [dbo].[EMP_ROM] ([EMP_NO], [APELLIDO], [OFICIO], [DIRECTOR], [FECHA_ALTA], [SALARIO], [COMISION], [DEP_NO]) VALUES (7698, N'GARRIDO', N'DIRECTOR', 7839, CAST(0x0000740900000000 AS DateTime), 3850.12, NULL, 30)
INSERT [dbo].[EMP_ROM] ([EMP_NO], [APELLIDO], [OFICIO], [DIRECTOR], [FECHA_ALTA], [SALARIO], [COMISION], [DEP_NO]) VALUES (7782, N'MARTINEZ', N'DIRECTOR', 7839, CAST(0x0000743000000000 AS DateTime), 2450, NULL, 10)
INSERT [dbo].[EMP_ROM] ([EMP_NO], [APELLIDO], [OFICIO], [DIRECTOR], [FECHA_ALTA], [SALARIO], [COMISION], [DEP_NO]) VALUES (7839, N'REY', N'PRESIDENTE', NULL, CAST(0x000074D100000000 AS DateTime), 6000, NULL, 10)
INSERT [dbo].[EMP_ROM] ([EMP_NO], [APELLIDO], [OFICIO], [DIRECTOR], [FECHA_ALTA], [SALARIO], [COMISION], [DEP_NO]) VALUES (7844, N'CALVO', N'VENDEDOR', 7698, CAST(0x0000748B00000000 AS DateTime), 1800, 0, 30)
INSERT [dbo].[EMP_ROM] ([EMP_NO], [APELLIDO], [OFICIO], [DIRECTOR], [FECHA_ALTA], [SALARIO], [COMISION], [DEP_NO]) VALUES (7876, N'GIL', N'ANALISTA', 7782, CAST(0x0000757B00000000 AS DateTime), 3350, NULL, 20)
INSERT [dbo].[EMP_ROM] ([EMP_NO], [APELLIDO], [OFICIO], [DIRECTOR], [FECHA_ALTA], [SALARIO], [COMISION], [DEP_NO]) VALUES (7900, N'JIMENEZ', N'EMPLEADO', 7782, CAST(0x000076BD00000000 AS DateTime), 1400, NULL, 20)
/****** Object:  Table [dbo].[departamentos89]    Script Date: 03/24/2013 11:44:10 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING OFF
GO
CREATE TABLE [dbo].[departamentos89](
    [dep_no] [int] NOT NULL,
    [dnombre] [varchar](14) NULL,
    [localidad] [varchar](10) NULL,
 CONSTRAINT [PK2_DEP89] PRIMARY KEY CLUSTERED
(
    [dep_no] 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
SET ANSI_PADDING OFF
GO
INSERT [dbo].[departamentos89] ([dep_no], [dnombre], [localidad]) VALUES (10, N'CONTABILIDAD', N'BARCELONA')
INSERT [dbo].[departamentos89] ([dep_no], [dnombre], [localidad]) VALUES (20, N'INVESTIGACIon', N'VALENCIA')
INSERT [dbo].[departamentos89] ([dep_no], [dnombre], [localidad]) VALUES (30, N'VENTAS', N'MADRID')
INSERT [dbo].[departamentos89] ([dep_no], [dnombre], [localidad]) VALUES (40, N'PRODUCCION', N'SEVILLA')
INSERT [dbo].[departamentos89] ([dep_no], [dnombre], [localidad]) VALUES (50, N'xxxx', N'haina')
INSERT [dbo].[departamentos89] ([dep_no], [dnombre], [localidad]) VALUES (100, N'compras', N'hsins')
INSERT [dbo].[departamentos89] ([dep_no], [dnombre], [localidad]) VALUES (106, N'anita', N'la loba')
INSERT [dbo].[departamentos89] ([dep_no], [dnombre], [localidad]) VALUES (109, N'compras', N'la nigua')
INSERT [dbo].[departamentos89] ([dep_no], [dnombre], [localidad]) VALUES (200, N'XXX', N'CCC')
INSERT [dbo].[departamentos89] ([dep_no], [dnombre], [localidad]) VALUES (2000, N'alvvv', N'nnnn')
INSERT [dbo].[departamentos89] ([dep_no], [dnombre], [localidad]) VALUES (3000, N'COMPRAS', N'HAINA')
/****** Object:  Table [dbo].[departamentos3]    Script Date: 03/24/2013 11:44:10 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[departamentos3](
    [dep_no] [int] NOT NULL,
    [dnombre] [varchar](14) NULL,
    [localidad] [varchar](10) NULL,
 CONSTRAINT [PK3_DEP] PRIMARY KEY CLUSTERED
(
    [dep_no] 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
SET ANSI_PADDING OFF
GO
INSERT [dbo].[departamentos3] ([dep_no], [dnombre], [localidad]) VALUES (18, N'CONTABILIDAD', N'BARCELONA')
INSERT [dbo].[departamentos3] ([dep_no], [dnombre], [localidad]) VALUES (20, N'INVESTIGACION', N'VALENCIA')
INSERT [dbo].[departamentos3] ([dep_no], [dnombre], [localidad]) VALUES (30, N'VENTAS', N'MADRID')
INSERT [dbo].[departamentos3] ([dep_no], [dnombre], [localidad]) VALUES (40, N'PRODUCCION', N'SEVILLA')
/****** Object:  Table [dbo].[departamentos2]    Script Date: 03/24/2013 11:44:10 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[departamentos2](
    [dep_no] [int] NOT NULL,
    [dnombre] [varchar](14) NULL,
    [localidad] [varchar](10) NULL,
 CONSTRAINT [PK2_DEP] PRIMARY KEY CLUSTERED
(
    [dep_no] 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
SET ANSI_PADDING OFF
GO
INSERT [dbo].[departamentos2] ([dep_no], [dnombre], [localidad]) VALUES (15, N'CONTABILIDAD', N'BARCELONA')
INSERT [dbo].[departamentos2] ([dep_no], [dnombre], [localidad]) VALUES (20, N'INVESTIGACION', N'VALENCIA')
INSERT [dbo].[departamentos2] ([dep_no], [dnombre], [localidad]) VALUES (30, N'VENTAS', N'MADRID')
INSERT [dbo].[departamentos2] ([dep_no], [dnombre], [localidad]) VALUES (40, N'PRODUCCION', N'SEVILLA')
/****** Object:  Table [dbo].[DEPARTAMENTOS]    Script Date: 03/24/2013 11:44:10 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[DEPARTAMENTOS](
    [DEP_NO] [int] NOT NULL,
    [DNOMBRE] [varchar](14) NULL,
    [LOCALIDAD] [varchar](10) NULL,
 CONSTRAINT [PK_DEPARTAMENTOS_DEP_NO] PRIMARY KEY CLUSTERED
(
    [DEP_NO] 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
SET ANSI_PADDING OFF
GO
INSERT [dbo].[DEPARTAMENTOS] ([DEP_NO], [DNOMBRE], [LOCALIDAD]) VALUES (1, N'dsfdsf', N'ffff')
INSERT [dbo].[DEPARTAMENTOS] ([DEP_NO], [DNOMBRE], [LOCALIDAD]) VALUES (2, N'dsfd', N'dgfdg')
INSERT [dbo].[DEPARTAMENTOS] ([DEP_NO], [DNOMBRE], [LOCALIDAD]) VALUES (10, N'CONTABILIDAD  ', N'BARCELONA')
INSERT [dbo].[DEPARTAMENTOS] ([DEP_NO], [DNOMBRE], [LOCALIDAD]) VALUES (20, N'INVESTIGACIon', N'VALENCIA')
INSERT [dbo].[DEPARTAMENTOS] ([DEP_NO], [DNOMBRE], [LOCALIDAD]) VALUES (30, N'VENTAS', N'MADRID')
INSERT [dbo].[DEPARTAMENTOS] ([DEP_NO], [DNOMBRE], [LOCALIDAD]) VALUES (40, N'PRODUCCION', N'SEVILLA')
INSERT [dbo].[DEPARTAMENTOS] ([DEP_NO], [DNOMBRE], [LOCALIDAD]) VALUES (50, N'xxxx', N'haina')
INSERT [dbo].[DEPARTAMENTOS] ([DEP_NO], [DNOMBRE], [LOCALIDAD]) VALUES (80, N'PRUEBA', N'MAO')
INSERT [dbo].[DEPARTAMENTOS] ([DEP_NO], [DNOMBRE], [LOCALIDAD]) VALUES (100, N'compras', N'hsins')
INSERT [dbo].[DEPARTAMENTOS] ([DEP_NO], [DNOMBRE], [LOCALIDAD]) VALUES (106, N'anita', N'la loba')
INSERT [dbo].[DEPARTAMENTOS] ([DEP_NO], [DNOMBRE], [LOCALIDAD]) VALUES (109, N'compras', N'la nigua')
INSERT [dbo].[DEPARTAMENTOS] ([DEP_NO], [DNOMBRE], [LOCALIDAD]) VALUES (200, N'XXX', N'CCC')
INSERT [dbo].[DEPARTAMENTOS] ([DEP_NO], [DNOMBRE], [LOCALIDAD]) VALUES (1000, N'fdf', N'bbb')
INSERT [dbo].[DEPARTAMENTOS] ([DEP_NO], [DNOMBRE], [LOCALIDAD]) VALUES (2000, N'alvvv', N'nnnn')
INSERT [dbo].[DEPARTAMENTOS] ([DEP_NO], [DNOMBRE], [LOCALIDAD]) VALUES (3000, N'COMPRAS', N'HAINA')
/****** Object:  Table [dbo].[DEP1]    Script Date: 03/24/2013 11:44:10 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[DEP1](
    [DEP_NO] [int] NULL,
    [DNOMBRE] [varchar](14) NULL,
    [LOCALIDAD] [varchar](14) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
INSERT [dbo].[DEP1] ([DEP_NO], [DNOMBRE], [LOCALIDAD]) VALUES (10, N'XXX', N'SAN JOSE OCOA')
INSERT [dbo].[DEP1] ([DEP_NO], [DNOMBRE], [LOCALIDAD]) VALUES (20, N'INVESTIGACION', N'VALENCIA')
INSERT [dbo].[DEP1] ([DEP_NO], [DNOMBRE], [LOCALIDAD]) VALUES (30, N'VENTAS', N'MADRID')
INSERT [dbo].[DEP1] ([DEP_NO], [DNOMBRE], [LOCALIDAD]) VALUES (40, N'PRODUCCION', N'SEVILLA')
/****** Object:  View [dbo].[ClientesView1]    Script Date: 03/24/2013 11:44:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[ClientesView1] AS
SELECT * FROM ClientesMadr
UNION
SELECT * FROM ClientesBarc
GO
/****** Object:  View [dbo].[ClientesView]    Script Date: 03/24/2013 11:44:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[ClientesView] AS
SELECT * FROM ClientesMad
UNION
SELECT * FROM ClientesBar
GO
/****** Object:  StoredProcedure [dbo].[pprueba]    Script Date: 03/24/2013 11:44:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[pprueba]
@m1 smallint,
    @m2 smallint,
    @result smallint OUTPUT
AS
   SET @result = @m1* @m2
GO
/****** Object:  Table [dbo].[BAK_EMP]    Script Date: 03/24/2013 11:44:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[BAK_EMP](
    [EMP_NO] [int] NOT NULL,
    [APELLIDO] [varchar](8) NULL,
    [OFICIO] [varchar](10) NULL,
    [DIRECTOR] [int] NULL,
    [FECHA_ALTA] [datetime] NULL,
    [SALARIO] [float] NULL,
    [COMISION] [float] NULL,
    [DEP_NO] [int] NULL,
 CONSTRAINT [pk_bak_emp] PRIMARY KEY CLUSTERED
(
    [EMP_NO] 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
SET ANSI_PADDING OFF
GO
INSERT [dbo].[BAK_EMP] ([EMP_NO], [APELLIDO], [OFICIO], [DIRECTOR], [FECHA_ALTA], [SALARIO], [COMISION], [DEP_NO]) VALUES (7499, N'cuncun', N'trepador', 7698, CAST(0x000073C600000000 AS DateTime), 1900, 400, 30)
INSERT [dbo].[BAK_EMP] ([EMP_NO], [APELLIDO], [OFICIO], [DIRECTOR], [FECHA_ALTA], [SALARIO], [COMISION], [DEP_NO]) VALUES (7521, N'LOPEZ', N'EMPLEADO', 7782, CAST(0x0000741000000000 AS DateTime), 1350.5, NULL, 10)
INSERT [dbo].[BAK_EMP] ([EMP_NO], [APELLIDO], [OFICIO], [DIRECTOR], [FECHA_ALTA], [SALARIO], [COMISION], [DEP_NO]) VALUES (7698, N'GARRIDO', N'DIRECTOR', 7839, CAST(0x0000740900000000 AS DateTime), 3850.12, NULL, 30)
INSERT [dbo].[BAK_EMP] ([EMP_NO], [APELLIDO], [OFICIO], [DIRECTOR], [FECHA_ALTA], [SALARIO], [COMISION], [DEP_NO]) VALUES (7782, N'MARTINEZ', N'DIRECTOR', 7839, CAST(0x0000743000000000 AS DateTime), 2450, NULL, 10)
INSERT [dbo].[BAK_EMP] ([EMP_NO], [APELLIDO], [OFICIO], [DIRECTOR], [FECHA_ALTA], [SALARIO], [COMISION], [DEP_NO]) VALUES (7839, N'REY', N'PRESIDENTE', NULL, CAST(0x000074D100000000 AS DateTime), 6000, NULL, 10)
INSERT [dbo].[BAK_EMP] ([EMP_NO], [APELLIDO], [OFICIO], [DIRECTOR], [FECHA_ALTA], [SALARIO], [COMISION], [DEP_NO]) VALUES (7876, N'GIL', N'ANALISTA', 7782, CAST(0x0000757B00000000 AS DateTime), 3350, NULL, 20)
INSERT [dbo].[BAK_EMP] ([EMP_NO], [APELLIDO], [OFICIO], [DIRECTOR], [FECHA_ALTA], [SALARIO], [COMISION], [DEP_NO]) VALUES (7900, N'JIMENEZ', N'EMPLEADO', 7782, CAST(0x000076BD00000000 AS DateTime), 1400, NULL, 20)
/****** Object:  Table [dbo].[BAK_DEP]    Script Date: 03/24/2013 11:44:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[BAK_DEP](
    [DEP_NO] [int] NOT NULL,
    [DNOMBRE] [varchar](14) NULL,
    [LOCALIDAD] [varchar](10) NULL,
 CONSTRAINT [pk_bak_dep] PRIMARY KEY CLUSTERED
(
    [DEP_NO] 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
SET ANSI_PADDING OFF
GO
INSERT [dbo].[BAK_DEP] ([DEP_NO], [DNOMBRE], [LOCALIDAD]) VALUES (10, N'CONTABILIDAD', N'BARCELONA')
INSERT [dbo].[BAK_DEP] ([DEP_NO], [DNOMBRE], [LOCALIDAD]) VALUES (20, N'INVESTIGACION', N'VALENCIA')
INSERT [dbo].[BAK_DEP] ([DEP_NO], [DNOMBRE], [LOCALIDAD]) VALUES (30, N'VENTAS', N'MADRID')
INSERT [dbo].[BAK_DEP] ([DEP_NO], [DNOMBRE], [LOCALIDAD]) VALUES (40, N'PRODUCCION', N'SEVILLA')
/****** Object:  Table [dbo].[CLI2_T]    Script Date: 03/24/2013 11:44:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[CLI2_T](
    [IDCLI] [int] NULL,
    [IDEMP] [int] NULL,
    [NOMBRE] [varchar](50) NULL,
    [ESTATUS] [bit] NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[MICURSO_T]    Script Date: 03/24/2013 11:44:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[MICURSO_T](
    [IDCURSO] [int] NULL,
    [DESCRIPCION] [varchar](60) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[empresa1]    Script Date: 03/24/2013 11:44:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[empresa1](
    [idemp] [int] NOT NULL,
    [nombre] [varchar](50) NULL,
 CONSTRAINT [PK_empresa1] PRIMARY KEY CLUSTERED
(
    [idemp] 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
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[empresa_t]    Script Date: 03/24/2013 11:44:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[empresa_t](
    [cod_emp] [int] NOT NULL,
    [nomb_emp] [varchar](56) NULL,
    [direccion] [varchar](50) NULL,
    [estatus] [bit] NULL,
    [TELEFONO] [varchar](12) NULL,
 CONSTRAINT [pk_empresa_cod_emp] PRIMARY KEY CLUSTERED
(
    [cod_emp] 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
SET ANSI_PADDING OFF
GO
INSERT [dbo].[empresa_t] ([cod_emp], [nomb_emp], [direccion], [estatus], [TELEFONO]) VALUES (1, N'LA COTORRA QUE LLORA', N'EL ZOOLOGICO', 1, N'809-543-6894')
/****** Object:  Table [dbo].[T_CURSO]    Script Date: 03/24/2013 11:44:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[T_CURSO](
    [codigo] [int] NOT NULL,
    [descripcion] [varchar](50) NULL,
 CONSTRAINT [PK_T_CURSO] PRIMARY KEY CLUSTERED
(
    [codigo] 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
SET ANSI_PADDING OFF
GO
INSERT [dbo].[T_CURSO] ([codigo], [descripcion]) VALUES (1, N'informatica')
INSERT [dbo].[T_CURSO] ([codigo], [descripcion]) VALUES (2, N'compras')
INSERT [dbo].[T_CURSO] ([codigo], [descripcion]) VALUES (3, N'contabilidad')
INSERT [dbo].[T_CURSO] ([codigo], [descripcion]) VALUES (4, N'Limpieza')
/****** Object:  Table [dbo].[USUARIO]    Script Date: 03/24/2013 11:44:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[USUARIO](
    [usuario] [varchar](15) NULL,
    [clave] [varchar](20) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
INSERT [dbo].[USUARIO] ([usuario], [clave]) VALUES (N'egerman', N'1234')
INSERT [dbo].[USUARIO] ([usuario], [clave]) VALUES (N'admin', N'123')
/****** Object:  Table [dbo].[tvende]    Script Date: 03/24/2013 11:44:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[tvende](
    [EMP_NO] [int] NOT NULL,
    [APELLIDO] [varchar](8) NULL,
    [OFICIO] [varchar](10) NULL,
    [DIRECTOR] [int] NULL,
    [FECHA_ALTA] [datetime] NULL,
    [SALARIO] [float] NULL,
    [COMISION] [float] NULL,
    [DEP_NO] [int] NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
INSERT [dbo].[tvende] ([EMP_NO], [APELLIDO], [OFICIO], [DIRECTOR], [FECHA_ALTA], [SALARIO], [COMISION], [DEP_NO]) VALUES (7499, N'ALONSO', N'VENDEDOR', 7698, CAST(0x000073C600000000 AS DateTime), 1400, 400, 30)
INSERT [dbo].[tvende] ([EMP_NO], [APELLIDO], [OFICIO], [DIRECTOR], [FECHA_ALTA], [SALARIO], [COMISION], [DEP_NO]) VALUES (7654, N'MARTIN', N'VENDEDOR', 7698, CAST(0x0000749F00000000 AS DateTime), 1500, 1600, 30)
INSERT [dbo].[tvende] ([EMP_NO], [APELLIDO], [OFICIO], [DIRECTOR], [FECHA_ALTA], [SALARIO], [COMISION], [DEP_NO]) VALUES (7844, N'CALVO', N'VENDEDOR', 7698, CAST(0x0000748B00000000 AS DateTime), 1800, 0, 30)
/****** Object:  Table [dbo].[tdire]    Script Date: 03/24/2013 11:44:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[tdire](
    [EMP_NO] [int] NOT NULL,
    [APELLIDO] [varchar](8) NULL,
    [OFICIO] [varchar](10) NULL,
    [DIRECTOR] [int] NULL,
    [FECHA_ALTA] [datetime] NULL,
    [SALARIO] [float] NULL,
    [COMISION] [float] NULL,
    [DEP_NO] [int] NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
INSERT [dbo].[tdire] ([EMP_NO], [APELLIDO], [OFICIO], [DIRECTOR], [FECHA_ALTA], [SALARIO], [COMISION], [DEP_NO]) VALUES (7698, N'GARRIDO', N'DIRECTOR', 7839, CAST(0x0000740900000000 AS DateTime), 3850.12, NULL, 30)
INSERT [dbo].[tdire] ([EMP_NO], [APELLIDO], [OFICIO], [DIRECTOR], [FECHA_ALTA], [SALARIO], [COMISION], [DEP_NO]) VALUES (7782, N'MARTINEZ', N'DIRECTOR', 7839, CAST(0x0000743000000000 AS DateTime), 2450, NULL, 10)
/****** Object:  Table [dbo].[PRODUCTOS]    Script Date: 03/24/2013 11:44:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[PRODUCTOS](
    [PRODUCTO_NO] [int] NOT NULL,
    [DESCRIPCION] [varchar](30) NULL,
    [PRECIO_ACTUAL] [float] NULL,
    [STOCK_DISPONIBLE] [int] NULL,
 CONSTRAINT [PK_PRODUCTO_NO] PRIMARY KEY CLUSTERED
(
    [PRODUCTO_NO] 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
SET ANSI_PADDING OFF
GO
INSERT [dbo].[PRODUCTOS] ([PRODUCTO_NO], [DESCRIPCION], [PRECIO_ACTUAL], [STOCK_DISPONIBLE]) VALUES (10, N'MESA DESPACHO MOD. GAVIOTA', 550, 44)
INSERT [dbo].[PRODUCTOS] ([PRODUCTO_NO], [DESCRIPCION], [PRECIO_ACTUAL], [STOCK_DISPONIBLE]) VALUES (20, N'SILLA DIRECTOR MOD. BUFALO', 670, 15)
INSERT [dbo].[PRODUCTOS] ([PRODUCTO_NO], [DESCRIPCION], [PRECIO_ACTUAL], [STOCK_DISPONIBLE]) VALUES (30, N'ARMARIO NOGAL DOS PUERTAS', 460, 20)
INSERT [dbo].[PRODUCTOS] ([PRODUCTO_NO], [DESCRIPCION], [PRECIO_ACTUAL], [STOCK_DISPONIBLE]) VALUES (40, N'MESA MODELO UNIËN', 340, 15)
INSERT [dbo].[PRODUCTOS] ([PRODUCTO_NO], [DESCRIPCION], [PRECIO_ACTUAL], [STOCK_DISPONIBLE]) VALUES (50, N'ARCHIVADOR CEREZO', 1050, 20)
INSERT [dbo].[PRODUCTOS] ([PRODUCTO_NO], [DESCRIPCION], [PRECIO_ACTUAL], [STOCK_DISPONIBLE]) VALUES (60, N'CAJA SEGURIDAD MOD B222', 280, 15)
INSERT [dbo].[PRODUCTOS] ([PRODUCTO_NO], [DESCRIPCION], [PRECIO_ACTUAL], [STOCK_DISPONIBLE]) VALUES (70, N'DESTRUCTORA DE PAPEL A3', 450, 16)
INSERT [dbo].[PRODUCTOS] ([PRODUCTO_NO], [DESCRIPCION], [PRECIO_ACTUAL], [STOCK_DISPONIBLE]) VALUES (80, N'MODULO ORDENADOR MOD. ERGOS', 550, 25)
/****** Object:  StoredProcedure [dbo].[ProcBuscarPk]    Script Date: 03/24/2013 11:44:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[ProcBuscarPk]
  (
    @dep_no int
  )
 as
 begin
  select * from departamentos
  where DEP_NO =@dep_no
end
GO
/****** Object:  StoredProcedure [dbo].[proc_PRODUCTOSLoadByPrimaryKey]    Script Date: 03/24/2013 11:44:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
create proc [dbo].[proc_PRODUCTOSLoadByPrimaryKey]
(
  @ProductoNo int
)
as
select descripcion,precio_actual,stock_disponible
from productos
where producto_no = @ProductoNo
GO
/****** Object:  StoredProcedure [dbo].[Proc_EliminarDep]    Script Date: 03/24/2013 11:44:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
create proc [dbo].[Proc_EliminarDep]
  (
     @dep_no int
  )
  as
  begin
    delete departamentos
    where dep_no=@dep_no
 end
GO
/****** Object:  StoredProcedure [dbo].[proc_DEPARTAMENTOSLoadByPrimaryKey]    Script Date: 03/24/2013 11:44:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE procedure
  [dbo].[proc_DEPARTAMENTOSLoadByPrimaryKey]
(
   @DEPNO int
   --@DNOMBRE varchar(14),
   --@LOCALIDAD varchar(10)
)
as
select dep_no,dnombre,localidad
from departamentos
where DEP_NO=@DEPNO
GO
/****** Object:  StoredProcedure [dbo].[PROC_DEPARTAMENTO_UPDATE]    Script Date: 03/24/2013 11:44:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROC [dbo].[PROC_DEPARTAMENTO_UPDATE]
(
   @DEP_NO INT,
   @DNOMBRE VARCHAR(14),
   @LOCALIDAD VARCHAR(14)
)
AS
BEGIN
  UPDATE DEPARTAMENTOS
  SET DNOMBRE=@DNOMBRE,LOCALIDAD=@LOCALIDAD
  WHERE DEP_NO=@DEP_NO
END
GO
/****** Object:  StoredProcedure [dbo].[PROC_DEPARTAMENTO_INSERT]    Script Date: 03/24/2013 11:44:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROC [dbo].[PROC_DEPARTAMENTO_INSERT]
(
   @DEP_NO INT,
   @DNOMBRE VARCHAR(14),
   @LOCALIDAD VARCHAR(14)
)
AS
BEGIN
  INSERT INTO DEPARTAMENTOS
  (DEP_NO,DNOMBRE,LOCALIDAD)
  VALUES(@DEP_NO,@DNOMBRE,@LOCALIDAD)
END
GO
/****** Object:  StoredProcedure [dbo].[PROC_DEPARTAMENTO_DELETE]    Script Date: 03/24/2013 11:44:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROC [dbo].[PROC_DEPARTAMENTO_DELETE]
(
   @DEP_NO INT
)
AS
BEGIN
  DELETE DEPARTAMENTOS
  WHERE DEP_NO=@DEP_NO
END
GO
/****** Object:  StoredProcedure [dbo].[Proc_LlenarDepartamentosPk]    Script Date: 03/24/2013 11:44:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
create procedure [dbo].[Proc_LlenarDepartamentosPk]
(
   @dep_no int
  
)
as
begin

  SELECT dep_no,dnombre,localidad
    FROM departamentos
    where  DEP_NO=@dep_no 
   
 end
GO
/****** Object:  StoredProcedure [dbo].[Proc_InsertarDepto]    Script Date: 03/24/2013 11:44:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
create procedure [dbo].[Proc_InsertarDepto]
(
  @DEP_NO int,
  @DNOMBRE varchar(14),
  @LOCALIDAD varchar(10)
)
as
begin
  insert into departamentos
  (DEP_NO,DNOMBRE,LOCALIDAD)
  values (@DEP_NO,@DNOMBRE,@LOCALIDAD)
end
GO
/****** Object:  StoredProcedure [dbo].[Proc_InsertarDepartamento]    Script Date: 03/24/2013 11:44:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
create procedure [dbo].[Proc_InsertarDepartamento]
(
   @dep_no int,
   @dnombre varchar(14),
   @localidad varchar(10)
)
as
begin
 insert into departamentos
  values(@dep_no,@dnombre,@localidad)
    
 end
GO
/****** Object:  StoredProcedure [dbo].[PROC_INSERTARDEPART]    Script Date: 03/24/2013 11:44:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[PROC_INSERTARDEPART]
(
   @DEP_NO INT,
   @DNOMBRE VARCHAR(14),
   @LOCALIDAD VARCHAR(10)
)
AS
BEGIN
  INSERT INTO DEPARTAMENTOS
  VALUES(@DEP_NO,@DNOMBRE,@LOCALIDAD)
END
GO
/****** Object:  Table [dbo].[T_Estudiante]    Script Date: 03/24/2013 11:44:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[T_Estudiante](
    [Matricula] [varchar](13) NOT NULL,
    [Nombre] [varchar](60) NULL,
    [codigo] [int] NULL,
 CONSTRAINT [PK_T_Estudiante] PRIMARY KEY CLUSTERED
(
    [Matricula] 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
SET ANSI_PADDING OFF
GO
INSERT [dbo].[T_Estudiante] ([Matricula], [Nombre], [codigo]) VALUES (N'85-cmo-1-003', N'elvin german', 2)
/****** Object:  Table [dbo].[T_DETALLE_FACT]    Script Date: 03/24/2013 11:44:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[T_DETALLE_FACT](
    [NOFACTURA] [int] IDENTITY(1,1) NOT NULL,
    [PRODUCTO_NO] [int] NOT NULL,
    [DESCRIPCION] [varchar](50) NULL,
    [CANTIDAD] [int] NULL,
    [PRECIO] [float] NULL,
 CONSTRAINT [PK_T_DETALLE_FACT] PRIMARY KEY CLUSTERED
(
    [NOFACTURA] ASC,
    [PRODUCTO_NO] 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
SET ANSI_PADDING OFF
GO
SET IDENTITY_INSERT [dbo].[T_DETALLE_FACT] ON
INSERT [dbo].[T_DETALLE_FACT] ([NOFACTURA], [PRODUCTO_NO], [DESCRIPCION], [CANTIDAD], [PRECIO]) VALUES (1, 20, N'GATO NEGRO', 1, 45)
SET IDENTITY_INSERT [dbo].[T_DETALLE_FACT] OFF
/****** Object:  StoredProcedure [dbo].[VALIDARUSUARIO]    Script Date: 03/24/2013 11:44:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
create procedure [dbo].[VALIDARUSUARIO]
(
    @usuario varchar(15),
    @clave   varchar(20)
)
as
select COUNT(*)
from usuario
where usuario =@usuario and clave=@clave
GO
/****** Object:  StoredProcedure [dbo].[validarusu]    Script Date: 03/24/2013 11:44:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
/****** Script for SelectTopNRows command from SSMS  ******/
--create proc validarusu
create procedure [dbo].[validarusu]
(
   @usuario varchar(15),
   @clave varchar(20)
)
as
begin

  SELECT [usuario],[clave]
    FROM [CURSO].[dbo].[USUARIO]
    where usuario =@usuario and clave=@clave
 end
GO
/****** Object:  Table [dbo].[empleados89]    Script Date: 03/24/2013 11:44:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING OFF
GO
CREATE TABLE [dbo].[empleados89](
    [emp_no] [int] NOT NULL,
    [apellido] [varchar](8) NULL,
    [oficio] [varchar](15) NULL,
    [director] [int] NULL,
    [fecha_alta] [datetime] NULL,
    [dep_no] [int] NULL,
 CONSTRAINT [PK_EMPLEADOS_EMP_NO89] PRIMARY KEY CLUSTERED
(
    [emp_no] 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
SET ANSI_PADDING OFF
GO
INSERT [dbo].[empleados89] ([emp_no], [apellido], [oficio], [director], [fecha_alta], [dep_no]) VALUES (7499, N'ALONSO', N'VENDEDOR', 7698, CAST(0x000073C600000000 AS DateTime), 30)
INSERT [dbo].[empleados89] ([emp_no], [apellido], [oficio], [director], [fecha_alta], [dep_no]) VALUES (7521, N'LOPEZ', N'EMPLEADO', 7782, CAST(0x0000741000000000 AS DateTime), 10)
INSERT [dbo].[empleados89] ([emp_no], [apellido], [oficio], [director], [fecha_alta], [dep_no]) VALUES (7654, N'MARTIN', N'VENDEDOR', 7698, CAST(0x0000749F00000000 AS DateTime), 30)
INSERT [dbo].[empleados89] ([emp_no], [apellido], [oficio], [director], [fecha_alta], [dep_no]) VALUES (7698, N'GARRIDO', N'DIRECTOR', 7839, CAST(0x0000740900000000 AS DateTime), 30)
INSERT [dbo].[empleados89] ([emp_no], [apellido], [oficio], [director], [fecha_alta], [dep_no]) VALUES (7782, N'MARTINEZ', N'DIRECTOR', 7839, CAST(0x0000743000000000 AS DateTime), 10)
INSERT [dbo].[empleados89] ([emp_no], [apellido], [oficio], [director], [fecha_alta], [dep_no]) VALUES (7839, N'REY', N'PRESIDENTE', NULL, CAST(0x000074D100000000 AS DateTime), 10)
INSERT [dbo].[empleados89] ([emp_no], [apellido], [oficio], [director], [fecha_alta], [dep_no]) VALUES (7844, N'CALVO', N'VENDEDOR', 7698, CAST(0x0000748B00000000 AS DateTime), 30)
INSERT [dbo].[empleados89] ([emp_no], [apellido], [oficio], [director], [fecha_alta], [dep_no]) VALUES (7876, N'GIL', N'ANALISTA', 7782, CAST(0x0000757B00000000 AS DateTime), 20)
INSERT [dbo].[empleados89] ([emp_no], [apellido], [oficio], [director], [fecha_alta], [dep_no]) VALUES (7900, N'JIMENEZ', N'EMPLEADO', 7782, CAST(0x000076BD00000000 AS DateTime), 20)
/****** Object:  Table [dbo].[empleados3]    Script Date: 03/24/2013 11:44:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[empleados3](
    [emp_no] [int] NOT NULL,
    [apellido] [varchar](8) NULL,
    [oficio] [varchar](15) NULL,
    [director] [int] NULL,
    [fecha_alta] [datetime] NULL,
    [dep_no] [int] NULL,
 CONSTRAINT [PK_EMPLEADOS_EMP_NO3] PRIMARY KEY CLUSTERED
(
    [emp_no] 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
SET ANSI_PADDING OFF
GO
INSERT [dbo].[empleados3] ([emp_no], [apellido], [oficio], [director], [fecha_alta], [dep_no]) VALUES (7499, N'ALONSO', N'VENDEDOR', 7698, CAST(0x000073C600000000 AS DateTime), 30)
INSERT [dbo].[empleados3] ([emp_no], [apellido], [oficio], [director], [fecha_alta], [dep_no]) VALUES (7521, N'LOPEZ', N'EMPLEADO', 7782, CAST(0x0000741000000000 AS DateTime), 18)
INSERT [dbo].[empleados3] ([emp_no], [apellido], [oficio], [director], [fecha_alta], [dep_no]) VALUES (7654, N'MARTIN', N'VENDEDOR', 7698, CAST(0x0000749F00000000 AS DateTime), 30)
INSERT [dbo].[empleados3] ([emp_no], [apellido], [oficio], [director], [fecha_alta], [dep_no]) VALUES (7698, N'GARRIDO', N'DIRECTOR', 7839, CAST(0x0000740900000000 AS DateTime), 30)
INSERT [dbo].[empleados3] ([emp_no], [apellido], [oficio], [director], [fecha_alta], [dep_no]) VALUES (7782, N'MARTINEZ', N'DIRECTOR', 7839, CAST(0x0000743000000000 AS DateTime), 18)
INSERT [dbo].[empleados3] ([emp_no], [apellido], [oficio], [director], [fecha_alta], [dep_no]) VALUES (7839, N'REY', N'PRESIDENTE', NULL, CAST(0x000074D100000000 AS DateTime), 18)
INSERT [dbo].[empleados3] ([emp_no], [apellido], [oficio], [director], [fecha_alta], [dep_no]) VALUES (7844, N'CALVO', N'VENDEDOR', 7698, CAST(0x0000748B00000000 AS DateTime), 30)
INSERT [dbo].[empleados3] ([emp_no], [apellido], [oficio], [director], [fecha_alta], [dep_no]) VALUES (7876, N'GIL', N'ANALISTA', 7782, CAST(0x0000757B00000000 AS DateTime), 20)
INSERT [dbo].[empleados3] ([emp_no], [apellido], [oficio], [director], [fecha_alta], [dep_no]) VALUES (7900, N'JIMENEZ', N'EMPLEADO', 7782, CAST(0x000076BD00000000 AS DateTime), 20)
/****** Object:  Table [dbo].[empleados2]    Script Date: 03/24/2013 11:44:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[empleados2](
    [emp_no] [int] NOT NULL,
    [apellido] [varchar](8) NULL,
    [oficio] [varchar](15) NULL,
    [director] [int] NULL,
    [fecha_alta] [datetime] NULL,
    [dep_no] [int] NULL,
 CONSTRAINT [PK_EMPLEADOS_EMP_NO2] PRIMARY KEY CLUSTERED
(
    [emp_no] 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
SET ANSI_PADDING OFF
GO
INSERT [dbo].[empleados2] ([emp_no], [apellido], [oficio], [director], [fecha_alta], [dep_no]) VALUES (7499, N'ALONSO', N'VENDEDOR', 7698, CAST(0x000073C600000000 AS DateTime), 30)
INSERT [dbo].[empleados2] ([emp_no], [apellido], [oficio], [director], [fecha_alta], [dep_no]) VALUES (7521, N'LOPEZ', N'EMPLEADO', 7782, CAST(0x0000741000000000 AS DateTime), 15)
INSERT [dbo].[empleados2] ([emp_no], [apellido], [oficio], [director], [fecha_alta], [dep_no]) VALUES (7654, N'MARTIN', N'VENDEDOR', 7698, CAST(0x0000749F00000000 AS DateTime), 30)
INSERT [dbo].[empleados2] ([emp_no], [apellido], [oficio], [director], [fecha_alta], [dep_no]) VALUES (7698, N'GARRIDO', N'DIRECTOR', 7839, CAST(0x0000740900000000 AS DateTime), 30)
INSERT [dbo].[empleados2] ([emp_no], [apellido], [oficio], [director], [fecha_alta], [dep_no]) VALUES (7782, N'MARTINEZ', N'DIRECTOR', 7839, CAST(0x0000743000000000 AS DateTime), 15)
INSERT [dbo].[empleados2] ([emp_no], [apellido], [oficio], [director], [fecha_alta], [dep_no]) VALUES (7839, N'REY', N'PRESIDENTE', NULL, CAST(0x000074D100000000 AS DateTime), 15)
INSERT [dbo].[empleados2] ([emp_no], [apellido], [oficio], [director], [fecha_alta], [dep_no]) VALUES (7844, N'CALVO', N'VENDEDOR', 7698, CAST(0x0000748B00000000 AS DateTime), 30)
INSERT [dbo].[empleados2] ([emp_no], [apellido], [oficio], [director], [fecha_alta], [dep_no]) VALUES (7876, N'GIL', N'ANALISTA', 7782, CAST(0x0000757B00000000 AS DateTime), 20)
INSERT [dbo].[empleados2] ([emp_no], [apellido], [oficio], [director], [fecha_alta], [dep_no]) VALUES (7900, N'JIMENEZ', N'EMPLEADO', 7782, CAST(0x000076BD00000000 AS DateTime), 20)
/****** Object:  Table [dbo].[EMPLEADOS]    Script Date: 03/24/2013 11:44:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[EMPLEADOS](
    [EMP_NO] [int] NOT NULL,
    [APELLIDO] [varchar](8) NULL,
    [OFICIO] [varchar](10) NULL,
    [DIRECTOR] [int] NULL,
    [FECHA_ALTA] [datetime] NULL,
    [SALARIO] [float] NULL,
    [COMISION] [float] NULL,
    [DEP_NO] [int] NULL,
 CONSTRAINT [PK_EMPLEADOS_EMP_NO] PRIMARY KEY CLUSTERED
(
    [EMP_NO] 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
SET ANSI_PADDING OFF
GO
INSERT [dbo].[EMPLEADOS] ([EMP_NO], [APELLIDO], [OFICIO], [DIRECTOR], [FECHA_ALTA], [SALARIO], [COMISION], [DEP_NO]) VALUES (7499, N'ALONSO', N'VENDEDOR', 7698, CAST(0x000073C600000000 AS DateTime), 1400, 400, 30)
INSERT [dbo].[EMPLEADOS] ([EMP_NO], [APELLIDO], [OFICIO], [DIRECTOR], [FECHA_ALTA], [SALARIO], [COMISION], [DEP_NO]) VALUES (7521, N'LOPEZ', N'EMPLEADO', 7782, CAST(0x0000741000000000 AS DateTime), 1350.5, NULL, 10)
INSERT [dbo].[EMPLEADOS] ([EMP_NO], [APELLIDO], [OFICIO], [DIRECTOR], [FECHA_ALTA], [SALARIO], [COMISION], [DEP_NO]) VALUES (7654, N'MARTIN', N'VENDEDOR', 7698, CAST(0x0000749F00000000 AS DateTime), 1500, 1600, 30)
INSERT [dbo].[EMPLEADOS] ([EMP_NO], [APELLIDO], [OFICIO], [DIRECTOR], [FECHA_ALTA], [SALARIO], [COMISION], [DEP_NO]) VALUES (7698, N'GARRIDO', N'DIRECTOR', 7839, CAST(0x0000740900000000 AS DateTime), 3850.12, NULL, 30)
INSERT [dbo].[EMPLEADOS] ([EMP_NO], [APELLIDO], [OFICIO], [DIRECTOR], [FECHA_ALTA], [SALARIO], [COMISION], [DEP_NO]) VALUES (7782, N'MARTINEZ', N'DIRECTOR', 7839, CAST(0x0000743000000000 AS DateTime), 2450, NULL, 10)
INSERT [dbo].[EMPLEADOS] ([EMP_NO], [APELLIDO], [OFICIO], [DIRECTOR], [FECHA_ALTA], [SALARIO], [COMISION], [DEP_NO]) VALUES (7839, N'REY', N'PRESIDENTE', NULL, CAST(0x000074D100000000 AS DateTime), 6000, NULL, 10)
INSERT [dbo].[EMPLEADOS] ([EMP_NO], [APELLIDO], [OFICIO], [DIRECTOR], [FECHA_ALTA], [SALARIO], [COMISION], [DEP_NO]) VALUES (7844, N'CALVO', N'VENDEDOR', 7698, CAST(0x0000748B00000000 AS DateTime), 1800, 0, 30)
INSERT [dbo].[EMPLEADOS] ([EMP_NO], [APELLIDO], [OFICIO], [DIRECTOR], [FECHA_ALTA], [SALARIO], [COMISION], [DEP_NO]) VALUES (7876, N'GIL', N'ANALISTA', 7782, CAST(0x0000757B00000000 AS DateTime), 3350, NULL, 20)
INSERT [dbo].[EMPLEADOS] ([EMP_NO], [APELLIDO], [OFICIO], [DIRECTOR], [FECHA_ALTA], [SALARIO], [COMISION], [DEP_NO]) VALUES (7900, N'JIMENEZ', N'EMPLEADO', 7782, CAST(0x000076BD00000000 AS DateTime), 1400, NULL, 20)
/****** Object:  StoredProcedure [dbo].[Proc_BuscarDepto_ByPrimaryKey]    Script Date: 03/24/2013 11:44:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
create procedure [dbo].[Proc_BuscarDepto_ByPrimaryKey]
(
   @dep_no int
)
as
begin
  select *
  from departamentos
  where DEP_NO =@dep_no
end
GO
/****** Object:  StoredProcedure [dbo].[Proc_BuscarDepto_All]    Script Date: 03/24/2013 11:44:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
create procedure [dbo].[Proc_BuscarDepto_All]
as
begin
  select *
  from departamentos
end
GO
/****** Object:  StoredProcedure [dbo].[Proc_Buscar_Depa]    Script Date: 03/24/2013 11:44:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
create proc [dbo].[Proc_Buscar_Depa]
(
   @dep_no int
)
as
begin
  select *
  from departamentos
  where DEP_NO=@dep_no
end
GO
/****** Object:  StoredProcedure [dbo].[Proc_ActualizarDepto]    Script Date: 03/24/2013 11:44:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
create procedure [dbo].[Proc_ActualizarDepto]
(
  @DEP_NO int,
  @DNOMBRE varchar(14),
  @LOCALIDAD varchar(10)
)
as
begin
  update departamentos
  set DNOMBRE=@DNOMBRE
      ,LOCALIDAD=@LOCALIDAD
  where DEP_NO = @DEP_NO 
end
GO
/****** Object:  StoredProcedure [dbo].[PROC_actualizarDEP]    Script Date: 03/24/2013 11:44:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[PROC_actualizarDEP]
(
   @DEP_NO INT,
   @DNOMBRE VARCHAR(14),
   @LOCALIDAD VARCHAR(10)
)
AS
BEGIN
  update departamentos
  set DNOMBRE=@dnombre,LOCALIDAD =@localidad
  where DEP_NO=@dep_no
END
GO
/****** Object:  Table [dbo].[cli_t]    Script Date: 03/24/2013 11:44:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[cli_t](
    [idcli] [int] NOT NULL,
    [cod_emp] [int] NOT NULL,
    [nombcli] [varchar](50) NULL,
    [direccion] [varchar](50) NULL,
    [telefono] [varchar](50) NULL,
    [email] [varchar](120) NULL,
 CONSTRAINT [pk_cli_t_idcli] PRIMARY KEY CLUSTERED
(
    [idcli] 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
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[CLIENTES]    Script Date: 03/24/2013 11:44:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[CLIENTES](
    [CLIENTE_NO] [int] NOT NULL,
    [NOMBRE] [varchar](25) NULL,
    [LOCALIDAD] [varchar](14) NULL,
    [VENDEDOR_NO] [int] NULL,
    [DEBE] [float] NULL,
    [HABER] [float] NULL,
    [LIMITE_CREDITO] [float] NULL,
 CONSTRAINT [PK_CLIENTE_NO] PRIMARY KEY CLUSTERED
(
    [CLIENTE_NO] 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
SET ANSI_PADDING OFF
GO
INSERT [dbo].[CLIENTES] ([CLIENTE_NO], [NOMBRE], [LOCALIDAD], [VENDEDOR_NO], [DEBE], [HABER], [LIMITE_CREDITO]) VALUES (101, N'DISTRIBUCIONES GOMEZ', N'MADRID', 7499, 0, 0, 5000)
INSERT [dbo].[CLIENTES] ([CLIENTE_NO], [NOMBRE], [LOCALIDAD], [VENDEDOR_NO], [DEBE], [HABER], [LIMITE_CREDITO]) VALUES (102, N'LOGITRONICA S.L', N'BARCELONA', 7654, 0, 0, 5000)
INSERT [dbo].[CLIENTES] ([CLIENTE_NO], [NOMBRE], [LOCALIDAD], [VENDEDOR_NO], [DEBE], [HABER], [LIMITE_CREDITO]) VALUES (103, N'INDUSTRIAS LACTEAS S.A.', N'LAS ROZAS', 7844, 0, 0, 10000)
INSERT [dbo].[CLIENTES] ([CLIENTE_NO], [NOMBRE], [LOCALIDAD], [VENDEDOR_NO], [DEBE], [HABER], [LIMITE_CREDITO]) VALUES (104, N'TALLERES ESTESO S.A.', N'SEVILLA', 7654, 0, 0, 5000)
INSERT [dbo].[CLIENTES] ([CLIENTE_NO], [NOMBRE], [LOCALIDAD], [VENDEDOR_NO], [DEBE], [HABER], [LIMITE_CREDITO]) VALUES (105, N'EDICIONES SANZ', N'BARCELONA', 7499, 0, 0, 5000)
INSERT [dbo].[CLIENTES] ([CLIENTE_NO], [NOMBRE], [LOCALIDAD], [VENDEDOR_NO], [DEBE], [HABER], [LIMITE_CREDITO]) VALUES (106, N'SIGNOLOGIC S.A.', N'MADRID', 7654, 0, 0, 5000)
INSERT [dbo].[CLIENTES] ([CLIENTE_NO], [NOMBRE], [LOCALIDAD], [VENDEDOR_NO], [DEBE], [HABER], [LIMITE_CREDITO]) VALUES (107, N'MARTIN Y ASOCIADOS S.L.', N'ARAVACA', 7844, 0, 0, 10000)
INSERT [dbo].[CLIENTES] ([CLIENTE_NO], [NOMBRE], [LOCALIDAD], [VENDEDOR_NO], [DEBE], [HABER], [LIMITE_CREDITO]) VALUES (108, N'MANUFACTURAS ALI S.A.', N'SEVILLA', 7654, 0, 0, 5000)
/****** Object:  View [dbo].[ANALISTA_VW]    Script Date: 03/24/2013 11:44:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[ANALISTA_VW]
 AS
 SELECT EMP_NO,APELLIDO,OFICIO
 FROM EMPLEADOS
 WHERE OFICIO ='ANALISTA'
GO
/****** Object:  StoredProcedure [dbo].[Proc_BuscarOficio]    Script Date: 03/24/2013 11:44:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
create procedure [dbo].[Proc_BuscarOficio]
(
   @oficio varchar(10)
)
as
begin
  select *
  from empleados
  where oficio =@oficio
end
GO
/****** Object:  View [dbo].[Vendedores_vw]    Script Date: 03/24/2013 11:44:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
create view [dbo].[Vendedores_vw]
as            
select *
from empleados
where OFICIO ='vendedor'
GO
/****** Object:  View [dbo].[VENDEDOR_VW]    Script Date: 03/24/2013 11:44:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[VENDEDOR_VW]
AS
SELECT dep_no "No. Departamento",
       dnombre Departamento
FROM departamentos
WHERE dep_no=
  (SELECT dep_no
   FROM empleados
   WHERE oficio = 'VENDEDOR'
   GROUP BY dep_no
     HAVING COUNT(*)=
       (SELECT TOP 1 COUNT(*)
        FROM empleados
        WHERE oficio = 'VENDEDOR'
        GROUP BY dep_no
        ORDER BY 1 DESC
        )
  );
GO
/****** Object:  View [dbo].[SalarioMedio]    Script Date: 03/24/2013 11:44:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
create view [dbo].[SalarioMedio]
as            
SELECT dep_no "No. Departamento",
       AVG(salario)"Salario Medio"
FROM empleados
GROUP BY dep_no
  HAVING AVG(salario)>=( SELECT AVG(salario)
                         FROM empleados);
GO
/****** Object:  StoredProcedure [dbo].[proc_EMPLEADOSLoadByPrimaryKey]    Script Date: 03/24/2013 11:44:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
create proc [dbo].[proc_EMPLEADOSLoadByPrimaryKey]
(
  @EmpNo int
)
as
select apellido
from empleados
where emp_no = @EmpNo
GO
/****** Object:  StoredProcedure [dbo].[Proc_EmpleadosByPk]    Script Date: 03/24/2013 11:44:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
create proc [dbo].[Proc_EmpleadosByPk]
(
   @emp_no int
)
as
begin
  select *
  from empleados
  where EMP_NO=@emp_no
end
GO
/****** Object:  StoredProcedure [dbo].[PROC_CONSULTAEMPLE]    Script Date: 03/24/2013 11:44:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROC [dbo].[PROC_CONSULTAEMPLE]
 (
    @DEP_NO INT
 )
 AS
 BEGIN
   SELECT *
   FROM EMPLEADOS
   WHERE DEP_NO=@DEP_NO
END
GO
/****** Object:  StoredProcedure [dbo].[proc_CLIENTESLoadByPrimaryKey]    Script Date: 03/24/2013 11:44:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
create proc [dbo].[proc_CLIENTESLoadByPrimaryKey]
(
  @ClienteNo int
)
as
select nombre
from clientes
where CLIENTE_NO = @ClienteNo
GO
/****** Object:  Table [dbo].[PEDIDOS]    Script Date: 03/24/2013 11:44:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[PEDIDOS](
    [PEDIDO_NO] [int] NOT NULL,
    [PRODUCTO_NO] [int] NULL,
    [CLIENTE_NO] [int] NULL,
    [UNIDADES] [int] NULL,
    [FECHA_PEDIDO] [datetime] NULL,
 CONSTRAINT [PK_PEDIDO_NO] PRIMARY KEY CLUSTERED
(
    [PEDIDO_NO] 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
INSERT [dbo].[PEDIDOS] ([PEDIDO_NO], [PRODUCTO_NO], [CLIENTE_NO], [UNIDADES], [FECHA_PEDIDO]) VALUES (1000, 20, 103, 3, CAST(0x00008E5500000000 AS DateTime))
INSERT [dbo].[PEDIDOS] ([PEDIDO_NO], [PRODUCTO_NO], [CLIENTE_NO], [UNIDADES], [FECHA_PEDIDO]) VALUES (1001, 50, 106, 2, CAST(0x00008E5500000000 AS DateTime))
INSERT [dbo].[PEDIDOS] ([PEDIDO_NO], [PRODUCTO_NO], [CLIENTE_NO], [UNIDADES], [FECHA_PEDIDO]) VALUES (1002, 10, 101, 4, CAST(0x00008E5600000000 AS DateTime))
INSERT [dbo].[PEDIDOS] ([PEDIDO_NO], [PRODUCTO_NO], [CLIENTE_NO], [UNIDADES], [FECHA_PEDIDO]) VALUES (1003, 20, 105, 4, CAST(0x00008E5F00000000 AS DateTime))
INSERT [dbo].[PEDIDOS] ([PEDIDO_NO], [PRODUCTO_NO], [CLIENTE_NO], [UNIDADES], [FECHA_PEDIDO]) VALUES (1004, 40, 106, 8, CAST(0x00008E6300000000 AS DateTime))
INSERT [dbo].[PEDIDOS] ([PEDIDO_NO], [PRODUCTO_NO], [CLIENTE_NO], [UNIDADES], [FECHA_PEDIDO]) VALUES (1005, 30, 105, 2, CAST(0x00008E6300000000 AS DateTime))
INSERT [dbo].[PEDIDOS] ([PEDIDO_NO], [PRODUCTO_NO], [CLIENTE_NO], [UNIDADES], [FECHA_PEDIDO]) VALUES (1006, 70, 103, 3, CAST(0x00008E7100000000 AS DateTime))
INSERT [dbo].[PEDIDOS] ([PEDIDO_NO], [PRODUCTO_NO], [CLIENTE_NO], [UNIDADES], [FECHA_PEDIDO]) VALUES (1007, 50, 101, 2, CAST(0x00008E7400000000 AS DateTime))
INSERT [dbo].[PEDIDOS] ([PEDIDO_NO], [PRODUCTO_NO], [CLIENTE_NO], [UNIDADES], [FECHA_PEDIDO]) VALUES (1008, 10, 106, 6, CAST(0x00008E7E00000000 AS DateTime))
INSERT [dbo].[PEDIDOS] ([PEDIDO_NO], [PRODUCTO_NO], [CLIENTE_NO], [UNIDADES], [FECHA_PEDIDO]) VALUES (1009, 20, 105, 2, CAST(0x00008E8800000000 AS DateTime))
INSERT [dbo].[PEDIDOS] ([PEDIDO_NO], [PRODUCTO_NO], [CLIENTE_NO], [UNIDADES], [FECHA_PEDIDO]) VALUES (1010, 40, 102, 3, CAST(0x00008E9400000000 AS DateTime))
INSERT [dbo].[PEDIDOS] ([PEDIDO_NO], [PRODUCTO_NO], [CLIENTE_NO], [UNIDADES], [FECHA_PEDIDO]) VALUES (1011, 30, 106, 2, CAST(0x00008E9B00000000 AS DateTime))
INSERT [dbo].[PEDIDOS] ([PEDIDO_NO], [PRODUCTO_NO], [CLIENTE_NO], [UNIDADES], [FECHA_PEDIDO]) VALUES (1012, 10, 105, 3, CAST(0x00008E9200000000 AS DateTime))
INSERT [dbo].[PEDIDOS] ([PEDIDO_NO], [PRODUCTO_NO], [CLIENTE_NO], [UNIDADES], [FECHA_PEDIDO]) VALUES (1013, 30, 106, 2, CAST(0x00008E9200000000 AS DateTime))
INSERT [dbo].[PEDIDOS] ([PEDIDO_NO], [PRODUCTO_NO], [CLIENTE_NO], [UNIDADES], [FECHA_PEDIDO]) VALUES (1014, 20, 101, 4, CAST(0x00008EB200000000 AS DateTime))
INSERT [dbo].[PEDIDOS] ([PEDIDO_NO], [PRODUCTO_NO], [CLIENTE_NO], [UNIDADES], [FECHA_PEDIDO]) VALUES (1015, 70, 105, 4, CAST(0x00008EBB00000000 AS DateTime))
INSERT [dbo].[PEDIDOS] ([PEDIDO_NO], [PRODUCTO_NO], [CLIENTE_NO], [UNIDADES], [FECHA_PEDIDO]) VALUES (1017, 20, 105, 6, CAST(0x00008EBF00000000 AS DateTime))
INSERT [dbo].[PEDIDOS] ([PEDIDO_NO], [PRODUCTO_NO], [CLIENTE_NO], [UNIDADES], [FECHA_PEDIDO]) VALUES (1018, 10, 105, 5, CAST(0x000099BF00000000 AS DateTime))
INSERT [dbo].[PEDIDOS] ([PEDIDO_NO], [PRODUCTO_NO], [CLIENTE_NO], [UNIDADES], [FECHA_PEDIDO]) VALUES (1019, 10, 105, 1, CAST(0x000099BF00000000 AS DateTime))
INSERT [dbo].[PEDIDOS] ([PEDIDO_NO], [PRODUCTO_NO], [CLIENTE_NO], [UNIDADES], [FECHA_PEDIDO]) VALUES (1020, 20, 105, 5, CAST(0x000099BF00000000 AS DateTime))
INSERT [dbo].[PEDIDOS] ([PEDIDO_NO], [PRODUCTO_NO], [CLIENTE_NO], [UNIDADES], [FECHA_PEDIDO]) VALUES (1021, 70, 103, 3, CAST(0x000099E100000000 AS DateTime))
/****** Object:  Table [dbo].[Pedido_Master]    Script Date: 03/24/2013 11:44:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Pedido_Master](
    [PedidoNo] [int] NOT NULL,
    [ClienteNo] [int] NULL,
    [FechaPedido] [datetime] NULL,
    [MontoTotal] [float] NULL,
    [FormaPago] [varchar](50) NULL,
    [Despachar] [char](1) NULL,
    [EmpNo] [int] NULL,
PRIMARY KEY CLUSTERED
(
    [PedidoNo] 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
SET ANSI_PADDING OFF
GO
INSERT [dbo].[Pedido_Master] ([PedidoNo], [ClienteNo], [FechaPedido], [MontoTotal], [FormaPago], [Despachar], [EmpNo]) VALUES (1, 101, CAST(0x0000A0DC00D2F5EA AS DateTime), 1220, N'contado', N'S', 7499)
/****** Object:  Table [dbo].[Pedido_Detalle]    Script Date: 03/24/2013 11:44:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Pedido_Detalle](
    [PedidoNo] [int] NULL,
    [ProductoNo] [int] NULL,
    [Cantidad] [int] NULL,
    [Precio] [float] NULL,
    [Itbis] [float] NULL,
    [Descuento] [float] NULL,
    [SubTotal] [float] NULL
) ON [PRIMARY]
GO
INSERT [dbo].[Pedido_Detalle] ([PedidoNo], [ProductoNo], [Cantidad], [Precio], [Itbis], [Descuento], [SubTotal]) VALUES (1, 10, 1, 550, 550, 5, 550)
INSERT [dbo].[Pedido_Detalle] ([PedidoNo], [ProductoNo], [Cantidad], [Precio], [Itbis], [Descuento], [SubTotal]) VALUES (1, 20, 1, 670, 670, 5, 670)
/****** Object:  StoredProcedure [dbo].[proc_Pedido_MasterLoadByPrimaryKey]    Script Date: 03/24/2013 11:44:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
create proc [dbo].[proc_Pedido_MasterLoadByPrimaryKey]
(
   @PedidoNo int
)
as
select ClienteNo,EmpNo,FechaPedido,Despachar
from Pedido_Master
where PedidoNo = @PedidoNo
GO
/****** Object:  StoredProcedure [dbo].[proc_Pedido_MasterInsert]    Script Date: 03/24/2013 11:44:19 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE proc [dbo].[proc_Pedido_MasterInsert]
(
   @PedidoNo int,
   @ClienteNo int,
   @FechaPedido datetime,
   @MontoTotal float,
   @FormaPago varchar(50),
   @Despachar char(1),
   @EmpNo int
)
as
insert into Pedido_Master
(PedidoNo,ClienteNo,FechaPedido,MontoTotal,FormaPago,Despachar,EmpNo)
values(@PedidoNo,@ClienteNo,@FechaPedido,@MontoTotal,@FormaPago,@Despachar,@EmpNo)
GO
/****** Object:  StoredProcedure [dbo].[proc_Pedido_DetalleInsert]    Script Date: 03/24/2013 11:44:19 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
create proc [dbo].[proc_Pedido_DetalleInsert]
(
  @PedidoNo int,
  @ProductoNo int,
  @Cantidad int,
  @Precio float,
  @Itbis float,
  @Descuento float,
  @SubTotal float
)
as
insert into Pedido_Detalle
(PedidoNo,ProductoNo,Cantidad,Precio,Itbis,Descuento,SubTotal)
values(@PedidoNo,@ProductoNo,@Cantidad,@Precio,@Itbis,@Descuento,@SubTotal)
GO
/****** Object:  ForeignKey [FK_T_Estudiante_T_CURSO]    Script Date: 03/24/2013 11:44:18 ******/
ALTER TABLE [dbo].[T_Estudiante]  WITH CHECK ADD  CONSTRAINT [FK_T_Estudiante_T_CURSO] FOREIGN KEY([codigo])
REFERENCES [dbo].[T_CURSO] ([codigo])
GO
ALTER TABLE [dbo].[T_Estudiante] CHECK CONSTRAINT [FK_T_Estudiante_T_CURSO]
GO
/****** Object:  ForeignKey [FK_T_DETALLE_FACT_PRODUCTOS]    Script Date: 03/24/2013 11:44:18 ******/
ALTER TABLE [dbo].[T_DETALLE_FACT]  WITH CHECK ADD  CONSTRAINT [FK_T_DETALLE_FACT_PRODUCTOS] FOREIGN KEY([PRODUCTO_NO])
REFERENCES [dbo].[PRODUCTOS] ([PRODUCTO_NO])
GO
ALTER TABLE [dbo].[T_DETALLE_FACT] CHECK CONSTRAINT [FK_T_DETALLE_FACT_PRODUCTOS]
GO
/****** Object:  ForeignKey [FK_EMP_DEP_NO89]    Script Date: 03/24/2013 11:44:18 ******/
ALTER TABLE [dbo].[empleados89]  WITH CHECK ADD  CONSTRAINT [FK_EMP_DEP_NO89] FOREIGN KEY([dep_no])
REFERENCES [dbo].[departamentos89] ([dep_no])
ON UPDATE CASCADE
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[empleados89] CHECK CONSTRAINT [FK_EMP_DEP_NO89]
GO
/****** Object:  ForeignKey [FK_EMP_DEP_NO3]    Script Date: 03/24/2013 11:44:18 ******/
ALTER TABLE [dbo].[empleados3]  WITH CHECK ADD  CONSTRAINT [FK_EMP_DEP_NO3] FOREIGN KEY([dep_no])
REFERENCES [dbo].[departamentos3] ([dep_no])
ON UPDATE CASCADE
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[empleados3] CHECK CONSTRAINT [FK_EMP_DEP_NO3]
GO
/****** Object:  ForeignKey [FK_EMP_DEP_NO2]    Script Date: 03/24/2013 11:44:18 ******/
ALTER TABLE [dbo].[empleados2]  WITH CHECK ADD  CONSTRAINT [FK_EMP_DEP_NO2] FOREIGN KEY([dep_no])
REFERENCES [dbo].[departamentos2] ([dep_no])
ON UPDATE CASCADE
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[empleados2] CHECK CONSTRAINT [FK_EMP_DEP_NO2]
GO
/****** Object:  ForeignKey [FK_EMP_DEP_NO]    Script Date: 03/24/2013 11:44:18 ******/
ALTER TABLE [dbo].[EMPLEADOS]  WITH CHECK ADD  CONSTRAINT [FK_EMP_DEP_NO] FOREIGN KEY([DEP_NO])
REFERENCES [dbo].[DEPARTAMENTOS] ([DEP_NO])
GO
ALTER TABLE [dbo].[EMPLEADOS] CHECK CONSTRAINT [FK_EMP_DEP_NO]
GO
/****** Object:  ForeignKey [FK_EMP_DIRECTOR]    Script Date: 03/24/2013 11:44:18 ******/
ALTER TABLE [dbo].[EMPLEADOS]  WITH CHECK ADD  CONSTRAINT [FK_EMP_DIRECTOR] FOREIGN KEY([DIRECTOR])
REFERENCES [dbo].[EMPLEADOS] ([EMP_NO])
GO
ALTER TABLE [dbo].[EMPLEADOS] CHECK CONSTRAINT [FK_EMP_DIRECTOR]
GO
/****** Object:  ForeignKey [fk_cli_t_empresa]    Script Date: 03/24/2013 11:44:18 ******/
ALTER TABLE [dbo].[cli_t]  WITH CHECK ADD  CONSTRAINT [fk_cli_t_empresa] FOREIGN KEY([cod_emp])
REFERENCES [dbo].[empresa_t] ([cod_emp])
GO
ALTER TABLE [dbo].[cli_t] CHECK CONSTRAINT [fk_cli_t_empresa]
GO
/****** Object:  ForeignKey [FK_CLI_EMP_NO]    Script Date: 03/24/2013 11:44:18 ******/
ALTER TABLE [dbo].[CLIENTES]  WITH CHECK ADD  CONSTRAINT [FK_CLI_EMP_NO] FOREIGN KEY([VENDEDOR_NO])
REFERENCES [dbo].[EMPLEADOS] ([EMP_NO])
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[CLIENTES] CHECK CONSTRAINT [FK_CLI_EMP_NO]
GO
/****** Object:  ForeignKey [FK_PEDIDOS_CLIENTE_NO]    Script Date: 03/24/2013 11:44:18 ******/
ALTER TABLE [dbo].[PEDIDOS]  WITH CHECK ADD  CONSTRAINT [FK_PEDIDOS_CLIENTE_NO] FOREIGN KEY([CLIENTE_NO])
REFERENCES [dbo].[CLIENTES] ([CLIENTE_NO])
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[PEDIDOS] CHECK CONSTRAINT [FK_PEDIDOS_CLIENTE_NO]
GO
/****** Object:  ForeignKey [FK_PEDIDOS_PRODUCTO_NO]    Script Date: 03/24/2013 11:44:18 ******/
ALTER TABLE [dbo].[PEDIDOS]  WITH CHECK ADD  CONSTRAINT [FK_PEDIDOS_PRODUCTO_NO] FOREIGN KEY([PRODUCTO_NO])
REFERENCES [dbo].[PRODUCTOS] ([PRODUCTO_NO])
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[PEDIDOS] CHECK CONSTRAINT [FK_PEDIDOS_PRODUCTO_NO]
GO
/****** Object:  ForeignKey [FK__Pedido_Ma__Clien__1D7B6025]    Script Date: 03/24/2013 11:44:18 ******/
ALTER TABLE [dbo].[Pedido_Master]  WITH CHECK ADD FOREIGN KEY([ClienteNo])
REFERENCES [dbo].[CLIENTES] ([CLIENTE_NO])
GO
/****** Object:  ForeignKey [FK__Pedido_Ma__EmpNo__1E6F845E]    Script Date: 03/24/2013 11:44:18 ******/
ALTER TABLE [dbo].[Pedido_Master]  WITH CHECK ADD FOREIGN KEY([EmpNo])
REFERENCES [dbo].[EMPLEADOS] ([EMP_NO])
GO
/****** Object:  ForeignKey [FK__Pedido_De__Pedid__214BF109]    Script Date: 03/24/2013 11:44:18 ******/
ALTER TABLE [dbo].[Pedido_Detalle]  WITH CHECK ADD FOREIGN KEY([PedidoNo])
REFERENCES [dbo].[Pedido_Master] ([PedidoNo])
GO
/****** Object:  ForeignKey [FK__Pedido_De__Produ__22401542]    Script Date: 03/24/2013 11:44:18 ******/
ALTER TABLE [dbo].[Pedido_Detalle]  WITH CHECK ADD FOREIGN KEY([ProductoNo])
REFERENCES [dbo].[PRODUCTOS] ([PRODUCTO_NO])
GO

sábado, 16 de marzo de 2013

INSTANCIA MDI

Posted by Elvin German 14:44, under | No comments

LLAMAR LA INSTANCIA DE UN FORMULARIO MDI

            Frm_Empleados  llamar = null;

            llamar = Frm_Empleados.Instance();
            llamar.MdiParent = this;
            llamar.Show();

FUNCION DE LA INSTANCIA

        private static Frm_Empleados frmInstance = null;

        public static Frm_Empleados Instance()
        {
            if (((frmInstance == null)
                        || (frmInstance.IsDisposed == true)))
            {
                frmInstance = new Frm_Empleados();
            }
            frmInstance.BringToFront();
            return frmInstance;
        }

martes, 12 de marzo de 2013

Monográfico Romana entrega práctica final

Posted by Elvin German 8:34, under | No comments

La entrega de su práctica final y evaluación, será realizada el sábado 06 de abril, 2013, a partir de las tres y treinta de la tarde, en la sede de la universidad.

Saludos