All functions, whether built-in or user-defined, ... SQL Server always has offered built-in ... SQL Server 2000 has a new Table data type that lets you declare local variables as type table.