User Defined Function (UDF)

SQLServerCentral Article

Tokenizing a String Using PARSENAME

  • Article

SQL Server string manipulation using T-SQL leaves lots to be desired. Many postings and complaints about T-SQL deal with strings, but there are ways to work with it. Author Eli Leiba brings us a way to split out portions of a string that contains tokens with a user defined function. Read on to see how this is accomplished and the code used to perform the splitting.

1 (1)

You rated this post out of 5. Change rating

2004-12-27

12,103 reads

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)

You rated this post out of 5. Change rating

2003-06-18

12,268 reads

Blogs

Unused Indexes in SQL Server: Find them, vet them, and drop them safely

By

 Unused Indexes in SQL Server: Find them, vet them, and drop them safely Indexes are...

T-SQL Tuesday #191 Round Up

By

I hosted this month, late as it turns out, but we still had a...

Come See Me at the PASS Data Community Summit

By

I'm speaking on Quantum Computing at the PASS Data Community Summit. It's scheduled for...

Read the latest Blogs

Forums

Create an HTML Report on the Status of SQL Server Agent Jobs

By Nisarg Upadhyay

Comments posted to this topic are about the item Create an HTML Report on...

Connecting ERP system E2 and Extract Data , perform Transformation

By Rahulmsb5

Hello, May someone please help me how can I pull data from ERP named...

Slip Streaming Installs

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Slip Streaming Installs

Visit the forum

Question of the Day

Slip Streaming Installs

What does a slipstream installation mean?

See possible answers