SQL Server 2008新功能──传递表值参数

　　DECLARE @DataTable AS SalesHistoryTableType 
　　The following script adds 1,000 records into my @DataTable table variable: 
　　DECLARE @i SMALLINT 
　　SET @i = 1 
　　WHILE (@i <=1000) 
　　BEGIN 
　　INSERT INTO @DataTable(Product, SaleDate, SalePrice) 
　　VALUES ("Computer", DATEADD(mm, @i, "3/11/1919"), DATEPART(ms, GETDATE()) + (@i + 57)) 
　　INSERT INTO @DataTable(Product, SaleDate, SalePrice) 
　　VALUES("BigScreen", DATEADD(mm, @i, "3/11/1927"), DATEPART(ms, GETDATE()) + (@i + 13)) 
　　INSERT INTO @DataTable(Product, SaleDate, SalePrice) 
　　VALUES("PoolTable", DATEADD(mm, @i, "3/11/1908"), DATEPART(ms, GETDATE()) + (@i + 29)) 
　　SET @i = @i + 1 
　　END

EXECUTE usp_InsertBigScreenProducts 
@TableVariable = @DataTable

SELECT * FROM SalesHistory