From the course: Microsoft SQL Server 2016: Query Data
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Understanding stored procedures - SQL Server Tutorial
From the course: Microsoft SQL Server 2016: Query Data
Understanding stored procedures
- [Instructor] In this lesson, we'll introduce stored procedures. Stored procedures help us to reduce network traffic from client server scenarios to reduce the amount of data that gets passed back and forth. They can help us provide stronger security for the database by providing permissions only for the stored procedure to execute against the data, as opposed to allowing users to connect directly to it. They can allow us to reuse code. They're easier to maintain, and they can help improve performance over queries. A stored procedures are typically a group of one or more T-SQL statements. They can accept incoming parameters, and they can return multiple values. They can also contain programming statements for performing different database operations. They can return success or failure status to any calling application. And they typically come in four flavors. User defined, which are the type that we'll create in this lesson. And they represent typically database queries. Temporary…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.