Advanced Database Stored Procedures with IF-ELSE Condition (SQL Server)
Channel: Christian Hur
Date: 2018-03-30

⭕ Overview
In this video, I guide you through creating a stored procedure in SQL to fetch data from multiple tables. We begin by writing a procedure that retrieves data from a personnel table, focusing on joining it with the Human Resources table. This example helps illustrate how to manage and query complex datasets efficiently.

We start by defining the procedure name and specifying its parameters. In this case, we use a parameter to filter by last name. The core of the procedure is a `SELECT` statement that fetches relevant fields from the joined tables. By using an inner join, we connect the Personnel and Human Resources tables on their business entity IDs.

If you find this video helpful, please give it a thumbs up, share it with your friends, and subscribe to my channel for more tutorials and insights into programming. Your support helps me create more content to assist you in your learning journey. Thank you for watching!

⭕ Chapters
  0:00 -  Introduction
  5:20 -  Executing the Stored Procedure
  8:00 -  Setting default values
10:45 - IF statement

⭕ About me
I am a Web Instructor at Gateway Technical College, an Adjunct Professor at Boston University Metropolitan College, Web Instructor at University of California, Irvine - Division of Continuing Education.

⭕ Check out my author page: http://amazon.com/author/christianhur
⭕ My complete online training courses:
      ☑️ The DOM in JavaScript, jQuery, AngularJS, and React : https://www.linkedin.com/learning/the-dom-in-javascript-jquery-angularjs-and-react
      ☑️ Building JSF Web Applications with Java EE 7:  https://www.linkedin.com/learning/building-jsf-web-applications-with-java-ee-7
      ☑️ Troubleshooting Vue.js:  https://www.packtpub.com/application-development/troubleshooting-vuejs-video
      ☑️ Angular 7 New Features:  https://www.packtpub.com/web-development/angular-7-new-features-video
      ☑️ Full-Stack Web Development with Flask: https://www.packtpub.com/web-development/full-stack-web-development-flask-video
      ☑️ Full-Stack Web Development with Django & Angular 8: https://www.packtpub.com/web-development/full-stack-web-development-with-django-and-angular-8-video
      ☑️ Angular 9 New Features: https://www.packtpub.com/web-development/angular-9-new-features-video


⭕ Check out my book:
Developing Business Applications for the Web: With HTML, CSS, JSP, PHP, ASP.NET, and JavaScript is available on Amazon and MC Press. 
      ☑️ Link:  https://www.mc-store.com/collections/christian-hur/products/developing-business-applications-for-the-web-with-html-css-jsp-php-asp-net-and-javascript