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)
3,515 reads
Scalar UDF
2020-05-28
649 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
7,216 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,127 reads
Blogs
Mistakes IT Shops Without a DBA Make
By Kevin3NF
We get it. There’s no budget for a DBA on staff, or even a...
A New Word: Waldosia
By Steve Jones
waldosia– n. a condition in which you keep scanning faces in a crowd looking...
Deploy at Low Priority
By Zikato
Learn how to deploy schema changes in an always-online SQL Server environment without a...
Forums
Dynamic T-SQL Script Parameterization Using Python
Comments posted to this topic are about the item Dynamic T-SQL Script Parameterization Using...
Shadow AI Data Leak Risk or “From the Desk of I saw that Coming”
Comments posted to this topic are about the item Shadow AI Data Leak Risk...
Alternatives to Junk Dimensions in Data warehousing
Hello SSC, I am not sure if I posted this in the right spot,...
Question of the Day
Counting Bits IV
What does this code return in SQL Server 2022+?
select bit_count(2.4)See possible answers