Using table variables SQL Server 2000 has a new Table data type that lets you declare local variables as type table. ... Executing a UDF from a SQL statement is a huge step forward for SQL Server.