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,368 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

10,699 reads

Blogs

Learn some critical SQL Security with the MidnightDBAs (Thursday, Jan 20)

By

Friends, the MidnightDBAs have a plan for 2022. A capital-P Plan. And it involves...

CosmosDB and Consistency

By

I was doing a little work with CosmosDB recently, and there were a few...

Daily Coping 17 Jan 2022

By

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

Read the latest Blogs

Forums

Linked Server UPDATE & DELETE fails . But INSERT & SELECTs work fine

By CheBob

Hello, I have a Windows 2019 machine. I have SQL Server 2016 and the...

Extended Events - how can I query the location of File Target of an XE Session?

By Vladimir Isaev

If I know the XE Session name, is there a query to find out...

tricky query with patterns of consecutive rows

By rotcha99

Hi! I'm having struggle with selecting rows, that match "dynamic" rules as described: if...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Adding Time

See possible answers