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 ...

SQL Server 2008 provides a minimal set of tools — cursors and WHILE loops — to accomplish this task. I’ll take a closer look at each option and explain why it’s difficult to pinpoint which ...