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
viernes, 11 de abril de 2008
Suscribirse a:
Enviar comentarios (Atom)
No hay comentarios:
Publicar un comentario