From the course: SQL Server 2014 Essential Training

Unlock the full course today

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

Stored procedures

Stored procedures - SQL Server Tutorial

From the course: SQL Server 2014 Essential Training

Start my 1-month free trial

Stored procedures

“

- The next thing we'll look at, in the AdventureWorks Database, is the Programmability section, so, if we open up AdventureWorks2014, about halfway down, we see Programmability. It's a bit of an unusual word, not a word you see outside of Microsoft very often, but Microsoft is very powerful. I guess they can make up words if they want to. In SQL Server, Programmability is a grouping of different types of objects that provide some functionality, so we're going to write some code, that code will be compiled, and that compiled code will give us some functionality. If we open up the Programmability tree, the first thing we see is Stored Procedures, and a Stored Procedure is the most basic and most common Programmability item. I've staged some code for you to go ahead and create one of our own Stored Procedures, so, in the Exercise Files for this course, we'll just copy and paste all of this code into a New Query, and, before we run it, let's look at it. The first line has the keyword…

Contents