SQL 2012 Developer, Part 03 of 13: Functions

with expert Don Kiely

In this course you’ll learn about the three kinds of UDFs available in SQL Server and will see several examples of functions and how to use them. We’ll start by looking at scalar functions that return a single value, then will explore the two types of table-valued functions. These latter functions let you return a table data type that acts like an in-memory table. Once you understand how to create functions, you’ll realize that now you have almost too many options for writing code: views, stored procedures, the different kinds of functions, and others. So we’ll discuss how to decide which kind of code module to use in different situations, as well as some potential performance issues with using functions.


Intermediate | 1h 4m | April 01, 2013

DatabaseSQL DeveloperSQL ServerTSQL

Course Outline


Don Kiely

Don Kiely is a featured instructor on many of our SQL Server and Visual Studio courses. He is a nationally recognized author, instructor, and consultant specializing in Microsoft technologies. Don has many years of teaching experience, is the author or co-author of several programming books, and has spoken at many industry conferences and user groups. In addition, Don is a consultant for a variety of companies that develop distributed applications for public and private organizations.




Explore Our Blogs, Courses and Webinars