March 2001
Use UDFs in SQL Server 2000 to create new IDENTITY functionality.
SQL Server Magazine
February 2001
You can use data sets inside triggers and in stored procedure calls by creating permanent tables that emulate temporary tables.
SQL Server Magazine
February 2001
SQL Server introduces several new features that might have implications for whether and how you use fake temporary tables with this new release.
SQL Server Magazine
November 10, 2000
Here's a practical application of using a user-defined function (UDF) to manipulate complex numbers.
SQL Server Magazine