User Defined Function (UDF)

A User-Defined Function returns more rows

  • Article

The Problem Recently, while working with one of my clients, I came across a script in which I had to introduce a scalar User-Defined Function in the SELECT statement. The SELECT used to return around 750K records. However, after introducing the UDF, the row count significantly increased to 826K. There were no other changes made […]

4 (5)

2019-10-14

4,292 reads

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)

2004-12-27

10,560 reads

Blogs

Ethics in Modern Data at Music City Tech 2021

By

  On Sept 16, Christine and I presented our joint presentation on Ethics in Modern Data at...

Slides and Video from Building a Regret-free Foundation for your Data Factory Now Available

By

Last week, Kerry and I delivered a webinar with tips on how to set...

Daily Coping 16 Sep 2021

By

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

Read the latest Blogs

Forums

Getting the JSON Index

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Getting the JSON Index

A Great Use for AI

By Steve Jones - SSC Editor

Comments posted to this topic are about the item A Great Use for AI

How to Flatten JSON in Azure Data Factory?

By diponkar.paul

Comments posted to this topic are about the item How to Flatten JSON in...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers