You can join to a UDF. Using table variables 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.

Using PowerShell To Back Up SQL Server Express Edition By Brien Posey 06/13/2025 For as long as I can remember, I have always configured the computers within my own organization to store data on ...

Learn More. In this, Part 4 of a series on programming T-SQL, Gregory Larsen details how to set variables in calling T-SQL code while using sp_executesql.