Ben Richardson

Ben Richardson

Ben Richardson

Ben Richardson runs Acuity Training an IT training business offering classroom courses in London and Guildford, Surrey. A leading provider of SQL training the UK, it offers a full range of SQL training from introductory courses through to advanced administration and data warehouse training. Acuity’s blog
Ben Richardson
C:\Users\ben.ACUITYPLC\Desktop\screenshot2.png

How to use SQL Server built-in functions and create user-defined scalar functions

July 7, 2017 by

A function is a set of SQL statements that perform a specific task. Functions foster code reusability. If you have to repeatedly write large SQL scripts to perform the same task, you can create a function that performs that task. Next time instead of rewriting the SQL, you can simply call that function. A function accepts inputs in the form of parameters and returns a value. SQL Server comes with a set of built-in functions that perform a variety of tasks.

Read more »