Magazine article from our research archive:

T-SQL Enhancements in SQL Server 2008, Part 2

(ProQuest: ... denotes formula omitted.)

SQL Server 2008 offers so many important T-SQL enhancements, I ran out of space last month describing them (see "T-SQL Enhancements in SQL Server 2008," InstantDoc ID 99416). Now let's look at more T-SQL enhancements you might find useful.

1 Table-Valued Parameters

If you've ever needed to pass a large number of parameters to a stored procedure or function, you'll appreciate SQL Server 2008's support for table-valued parameters.

As you can see in Listing 1, I created a new Table Type called MyTableType. Next, I created a stored procedure that uses a table as a parameter. Last, you can see the new MyTableType variable that was populated and passed to ...

Related newspaper, magazine, and journal articles:

See all results. Or, try our Advanced Search.

Newsweek Harper's Magazine The Washington Post Chicago Tribune Crain's Chicago Business PRNewswire Pediatric News The Nation Advertising Age The Economist (US) A FREE trial gives you access to over 60 million articles! Access over 3,500 publications with a FREE trial!