The following script adds 1,000 records into my @DataTable table variable: DECLARE @i SMALLINT SET @i = 1 ... SQL Server 2008’s table parameter feature is a huge step forward in terms of ...

SQL Server 2000 has a new Table data type that lets you declare local variables as type table. The table type is available only via a UDF. Stored procedures can create and populate a table, but a ...