Stairway to Advanced T-SQL Level 10: Using Scalar Functions
Learn about scalar user defined functions in this next level in the Stairway.
2020-10-21 (first published: 2020-10-08)
2,939 reads
Scalar UDF
2020-05-28
635 reads
The Case for Scalar-valued, User-defined Functions in T-SQL
Did you know that scalar-valued, user-defined functions can be used in DEFAULT/CHECK CONSTRAINTs and computed columns? Learn about it...
2015-05-12
6,871 reads
Calculating the Number of Business Hours Passed Since a Point of Time
A set of user defined functions used to calculate the number of business or working hours (excluding the non working hours) that have passed since a certain point of time.
2011-09-21 (first published: 2007-11-20)
3,046 reads
Blogs
Creating a new User-Defined Data Type–#SQLNewBlogger
By Steve Jones
Another post for me that is simple and hopefully serves as an example for...
A new chapter begins
In 2012 when I originally founded Born SQL, I never imagined I would find...
Daily Coping 19 Jan 2022
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
Recursive Triggers
I know there is, somewhere, T-SQL that will allow me to update (keep in...
How to get cummulative sum per column?
Hi, I have a statement per period. I want the periods to be cumulate. ...
Ask SSC