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,054 reads
Learn about scalar user defined functions in this next level in the Stairway.
2020-10-21 (first published: 2020-10-08)
3,054 reads
2020-05-28
639 reads
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,914 reads
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,058 reads
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Over the past couple of years, I’ve developed several tools that I’ve been using...
/* Author:Brahmanand Shukla (SQLServerCarpenter.com) Date:27-May-2022 Purpose:To get all the stored procedures and triggers missing the use of...
Can someone let me know why I'm not able to use CAST method to...
If i deploy a standalone Azure VM running SQL Server into an availavility zone;...
So I have inherited an older SQL 2014 Server and have been working on...