From the course: Microsoft SQL Server 2019 Essential Training

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Create stored procedures

Create stored procedures - SQL Server Tutorial

From the course: Microsoft SQL Server 2019 Essential Training

Start my 1-month free trial

Create stored procedures

“

- [Instructor] I'd like to take a look at creating our first stored procedure using the WideWorldImporters database. To see what stored procedures already exist in the database, you can use the object explore and go into the programmability folder, and then find the stored procedures folder. You'll notice that WideWorldImporters already has a number of stored procedures that have been created in this database. Another way to get to this same information is to run a select statement against one of the system tables, the sys.procedures table. Let me highlight lines six through 11 in my script here and execute the statement. You'll see that the results here mirror the same information that we're seeing over in the stored procedures folder. If you want to explore how a particular stored procedure was created and the commands that it contains, we simply need to find one that we want to work with. I'm going to scroll down and find one called Website.SearchForPeople. Then you can right click…

Contents