The Broken UDF
- QotD Question
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 […]
This article describes and demonstrates the problem of using asterisk to select all fields from a table within a table function. (from Apr 2008)
2009-09-11 (first published: 2008-04-30)
This UDF returns a multi column table of values from an input string of comma separated values
2008-06-11 (first published: 2008-04-29)
Get given character's position from a string
2008-02-13 (first published: 2007-12-18)
In the simplest terms, a user-defined function (UDF) in SQL Server is a programming construct that accepts parameters, does work that typically makes use of the accepted parameters, and returns a type of result. This article will cover two types of UDFs: table-valued and scalar-valued.
Calculates the nth due date for any given date, while accounting for weekends.
2012-05-16 (first published: 2007-10-11)
Computed columns in SQL Server 2000 allow you to have a calculated value available easily in a query. However by using a function instead of a simple formula you can build some very interesting solutions. New author Tim Chapman brings us a look at this technique.
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.
By Chris Yates
Data continues to be the lifeline for companies across the globe. As maturity levels...
By Steve Jones
Today’s coping tip is to get outside and notice how the weather feels. This...
Hello Dear Reader! What an incredible week we had. I started off traveling on...
Kamagra 100 capsule will help the people who are troubled with erectile dysfunction. The...
Hello! Backups are automated for Azure SQL Prod environment, we can do point-in-time recovery...
Hi all, I am running the following query in SQL, trying to export some...
SQL Server Q&A from the SQLServerCentral communityGet answers