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,088 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,158 reads

Blogs

Azure Synapse Analytics overlooked features

By

There are some options in Azure Synapse Analytics that are not obvious that I...

Review: Stellar Repair for SQL Server

By

I was contacted by Stellar Info quite a while ago. They asked me to...

Daily Coping 23 Sep 2020

By

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

Read the latest Blogs

Forums

Validate field in STaging before loading

By Bruin

I have a STaging table where I have defined all fields as Varchar(255), now...

Azure Log Analytics or SQL Profiler for AAS?

By imani_technology

I think you can use both SQL Server Profiler or Azure Log Analytics for...

Key Lookup to Clustered Index

By Adam Bean

Hey all, Been a bit since I've been down this road. Clearly I'd assume...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers