Base de datos VENTAS

USE [VENTAS]
GO
/****** Object:  StoredProcedure [dbo].[SP_PRODUCTO_GRABAR]    Script Date: 07/13/2013 18:52:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[SP_PRODUCTO_GRABAR]
            @pNombre VARCHAR(50),
            @pPrecio DECIMAL(10,4),
            @pIdCategoria INT
    AS
    BEGIN
            INSERT INTO PRODUCTO (Nombre, Precio, IdCategoria) VALUES (@pNombre, @pPrecio, @pIdCategoria)
    END
GO
/****** Object:  StoredProcedure [dbo].[SP_PRODUCTO_ACTUALIZAR]    Script Date: 07/13/2013 18:52:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[SP_PRODUCTO_ACTUALIZAR]
            @pIdProducto INT,
            @pNombre VARCHAR(50),
            @pPrecio DECIMAL(10,4),
            @pIdCategoria INT
    AS
    BEGIN
            UPDATE PRODUCTO SET Nombre = @pNombre, Precio = @pPrecio, IdCategoria = @pIdCategoria WHERE IdProducto = @pIdProducto
    END
GO
/****** Object:  StoredProcedure [dbo].[SP_PRODUCTO_BORRAR]    Script Date: 07/13/2013 18:52:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[SP_PRODUCTO_BORRAR]
            @pIdProducto INT
    AS
    BEGIN
            DELETE FROM Producto WHERE IdProducto = @pIdProducto
    END
GO
/****** Object:  Table [dbo].[CATEGORIA]    Script Date: 07/13/2013 18:53:02 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[CATEGORIA](
    [IdCategoria] [INT] IDENTITY(1,1) NOT NULL,
    [NombreCat] [VARCHAR](50) NOT NULL,
 CONSTRAINT [PK_CATEGORIA] PRIMARY KEY CLUSTERED
(
    [IdCategoria] 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:  StoredProcedure [dbo].[SP_PRODUCTO_LISTAR_TODO_POR_CATEGORIA]    Script Date: 07/13/2013 18:53:00 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[SP_PRODUCTO_LISTAR_TODO_POR_CATEGORIA]
            @pIdCategoria INT
    AS
    BEGIN
            SELECT * FROM PRODUCTO WHERE IdCategoria = @pIdCategoria
    END
GO
/****** Object:  Table [dbo].[PRODUCTO]    Script Date: 07/13/2013 18:53:03 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[PRODUCTO](
    [IdProducto] [INT] IDENTITY(1,1) NOT NULL,
    [Nombre] [VARCHAR](50) NOT NULL,
    [Precio] [DECIMAL](10, 2) NOT NULL,
    [IdCategoria] [INT] NOT NULL,
 CONSTRAINT [PK_PRODUCTO] PRIMARY KEY CLUSTERED
(
    [IdProducto] 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:  StoredProcedure [dbo].[SP_PRODUCTO_LISTAR_TODO]    Script Date: 07/13/2013 18:53:00 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[SP_PRODUCTO_LISTAR_TODO]

    AS
    BEGIN
            SELECT * FROM PRODUCTO ORDER BY IdProducto DESC
    END
GO
/****** Object:  StoredProcedure [dbo].[SP_CATEGORIA_LISTAR_TODO]    Script Date: 07/13/2013 18:52:58 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[SP_CATEGORIA_LISTAR_TODO]

    AS
    BEGIN
            SELECT * FROM CATEGORIA
    END
GO
/****** Object:  ForeignKey [FK_PRODUCTO_CATEGORIA]    Script Date: 07/13/2013 18:53:03 ******/
ALTER TABLE [dbo].[PRODUCTO]  WITH CHECK ADD  CONSTRAINT [FK_PRODUCTO_CATEGORIA] FOREIGN KEY([IdCategoria])
REFERENCES [dbo].[CATEGORIA] ([IdCategoria])
GO
ALTER TABLE [dbo].[PRODUCTO] CHECK CONSTRAINT [FK_PRODUCTO_CATEGORIA]
GO