Explore single-value functions SQL Server


show more Exploring single-value functions provides you with in-depth training on Business. Taught by Martin Guidry as part of the SQL Server: Triggers, Stored Procedures, and Functions show less
please wait ...

Exploring single-value functions

Now I would like to talk a little more about user defined functions, specifically, when Microsoft calls a Scalar-valued Function. Scalar is a single piece of data, such as a single number, a single date, a single piece of text. So any function that returns a single piece of data is called a Scalar-valued Function. These are the most common functions we work with in Microsoft SQL Server. In this example, we will be working with some of the code in your exercise files. The first thing, I'd like to do is populate the authors table with a few addresses.

We're going to be working through some examples with addresses. And right now no one has an address yet, so we'll go ahead and execute some code that should give two our users some addresses. Yes, look at that, now John Doe and Sally Smith both have valid addresses. So now looking at the code that creates the function; the function is called format addresses. It takes four inputs one called city, one called street, one called state...

Exploring single-value functions
Video duration: 4m 18s 1h 52m Advanced

Viewers:

Exploring single-value functions provides you with in-depth training on Business. Taught by Martin Guidry as part of the SQL Server: Triggers, Stored Procedures, and Functions

Subjects:
Business Developer IT
Software:
SQL Server
Author:
please wait ...