viernes, 11 de abril de 2008

Parametro tipo Tabla en SQL Server 2008

USE AdventureWorks;
GO

CREATE TYPE TipoTabla AS TABLE
(Nombre VARCHAR(50), Costo INT);

GO

CREATE PROCEDURE InsertaAreasDeProduccion
@ParametroTabla TipoTabla READONLY
AS
SET NOCOUNT ON
INSERT INTO [AdventureWorks].[Production].[Location]
([Name], [CostRate], [Availability], [ModifiedDate])
SELECT *, 0, GETDATE()
FROM @ParametroTabla;
GO

DECLARE @TablaLocation AS TipoTabla;

INSERT INTO @TablaLocation (Nombre, Costo)
SELECT [Name], 0.00
FROM [AdventureWorks].[Person].[StateProvince];

EXEC InsertaAreasDeProduccion @TablaLocation;
GO

No hay comentarios: