Design T-SQL Table-Valued and Scalar Functions

Introduction

The Design T-SQL table-valued and scalar function module provides you with the instruction and server hardware to develop your hands on skills in the defined topics. This module includes the following exercises:

1. Work with Scalar and Table Valued Function
2. Implement Set based vs Procedural Approach

Exercise 1 - Work with Scalar and Table Valued Function

In this exercise, you will learn the following in Microsoft SQL Server 2012 R2:

• Create a scalar valued function
• Create a table valued function

Exercise 2 – Implement Set Based Vs Procedural Approach

In this exercise, you will implement set based and procedural (cursor) approach.