UDFs return table variables. You can call a UDF from a SELECT statement. You can join to a UDF. SQL Server 2000 has a new Table data type that lets you declare local variables as type table.

Gregory Larsen details how to set variables in calling T-SQL code while using sp_executesql. Read the full story at DBAzine.com. Subscribe to Daily Tech Insider for top news, trends & analysis ...