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,741 reads
Scalar UDF
2020-05-28
627 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,799 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,033 reads
Blogs
3 Reasons Why Focusing on Tech Is The Worst Way To Deploy a HA/DR Solution
By kleegeek
This past Thursday, Edwin Sarmiento presented a session for our Microsoft Data Platform Continuity...
The PowerBI Volleyball Report – Organizing Data To Start
By Steve Jones
One of my goals this year was to build a report that I can...
Daily Coping 2 Aug 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
Need to change RS Execution Acct PWD, automatically w/ T-SQL
We use a 3rd party vendor to administer our SQL Server service account PWDS....
NOT IN vs. NOT EXISTS
This is a basic question which occurred to me while reading something on the...
Bulk Insert 4832, 7399, and 7330 errors
Hello all, I was wondering if someone can shed some light on my dilemma....
Ask SSC