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,610 reads
Scalar UDF
2020-05-28
621 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,719 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,022 reads
Blogs
The PowerShell Basics If Statement–#SQLNewBlogger
By Steve Jones
Another post for me that is simple and hopefully serves as an example for...
T-SQL Tuesday Retrospective #013: What the business wants
Click here to read previous retrospective entries. From Steve Jones (blog | Twitter) in December 2010...
Daily Coping 14 Apr 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
Last day of the previous month - Format MM/DD/YYYY
I use the below to get Last day of Previous Month, but I want...
How to change schema of all tables, views and stored procedures in MSSQL
Hello Community, I trying to use the following sql code to change the Schema...
Changing SSAS TCP port directly in config file
Goodday, I have a problem with changing the TCP port for SQL Server Analysis...
Ask SSC