User Defined Function (UDF)

SQLServerCentral Article

UDF as Computed Column

  • Article

UDF's are useful if somewhat tricky. Dinesh uses a common scenario where you have a self referencing table (the common example is an employees table where each employee has a managerid that links to another employee in the same table) to illustrate how a UDF can make querying easier, how to use it as the basis of a computed column, and how to index that column.

5 (2)

2003-06-18

11,557 reads

Blogs

Daily Coping 5 Aug 2022

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Daily Coping 4 Aug 2022

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

What’s next III

By

In case you didn’t know I was given notice about a month and a...

Read the latest Blogs

Forums

Truncate partition table failed due to index not partition. Help please.

By JasonO

I have 1 table which has a partition on Date column. However this table...

Finding Special Characters in Email Address

By sathishkm

Hi All, I have to find the special characters in email address apart from...

Three Mile Island And Your Databases

By Grant Fritchey

Comments posted to this topic are about the item Three Mile Island And Your...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers