Join Martin Guidry for an in-depth discussion in this video Exploring single-value functions, part of SQL Server: Triggers, Stored Procedures, and 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…and one called zip.…
- Comparing triggers, functions, and stored procedures
- Installing and configuring SQL Server
- Creating a stored procedure
- Returning data using data sets
- Creating user-defined functions
- Using "after," "instead," and nested triggers
- Modifying existing stored procedures
- Implementing logging on DELETE
- Choosing between T-SQL and CLR
- Executing a stored procedure
- Passing parameters
Skill Level Advanced
1. Getting Started
2. Installing SQL Server
Configuring your environment4m 53s
3. Stored Procedures
4. User-Defined Functions
6. Putting It All Together
7. Using CLR Assemblies
8. Exploring an ASP.NET Web Application
Next steps1m 43s
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.