Preview Stored Procedures and Functions Unpacked

1. Introduction

About this course

2. Getting started with SQL Server Stored Procedures

1. Stored Procedures-Getting Started

2. Multiple scenarios using Parameters in Stored Procedures

3. Using Output Parameters in Stored Procedures

4. Multiple scenarios using Variables in Stored Procedures

SQL Scripts

3. Stored Procedures: Using Control-Flow statements

If-Else: Control Flow Statement

While: Control Flow Statement

Break: Control Flow Statement

Continue: Control Flow Statement

Control Flow - SQL Scripts

4. Stored Procedures: Using CURSOR

Using CURSOR in Stored Procedures

CURSOR - SQL script

5. Stored Procedures: Handling Exceptions

Handling Exceptions in Stored Procedures: Using Try Catch

Handling Exceptions in Stored Procedures: Using RaiseError

Handling Exceptions in Stored Procedures: Using Throw

Handling Exceptions -SQL Scripts

6. Stored Procedures: Using dynamic SQL

Using dynamic SQL in Stored Procedures

dynamic SQL Script

7. Working with Functions

System-defined scalar function

System-defined aggregate function

User-defined scalar function

User-defined inline table-valued function

User-defined multi-statement table-valued function

SQL Scripts

8. Course completion

Thank You!