User Defined Function (UDF)

SQLServerCentral Article

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,528 reads

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)

2004-12-27

11,289 reads

Blogs

Is Cataloging Your Data Important?

By

Data continues to be the lifeline for companies across the globe. As maturity levels...

Daily Coping 20 Mar 2023

By

Today’s coping tip is to get outside and notice how the weather feels. This...

Tales From The Field Weekly Wrap Up for the Week of 03-13-2023 & SQLBits 2023

By

 Hello Dear Reader!  What an incredible week we had.  I started off traveling on...

Read the latest Blogs

Forums

Buy Kamagra Medicament | USA/UK

By buymygenerix

Kamagra 100 capsule will help the people who are troubled with erectile dysfunction. The...

Azure SQL - Restore to lower enviornment

By PJ_SQL

Hello! Backups are automated for Azure SQL Prod environment, we can do point-in-time recovery...

Bcp queryout issue

By kakovatos7

Hi all, I am running the following query in SQL, trying to export some...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers