Join Martin Guidry for an in-depth discussion in this video Why use a stored procedure?, part of SQL Server: Triggers, Stored Procedures, and Functions.
- View Offline
- Exercise Files
Now I'd like to talk about some of the advantages of using stored procedures.…One of the primary advantages is to simplify the administration and maintenance…for common routines.…On a large database project we could have dozens of developers writing code to…read and manipulate data in the same table.…If each developer independently writes a simple INSERT statement for the table,…there is a large chance someone will make an error.…Also, if that table ever changes, every single developer has to go back…and change their code.…
However, if we wrote one insert stored procedure and allowed all the developers…to use that stored procedure, we gain some advantages.…First, we reduce the chances of error.…We also reduce the level of effort when a change is required.…We can simply change the stored procedure.…As long as the name of the stored procedure and the input parameters of…the stored procedure stay the same, the developers will likely have no…need to change their code.…Another advantage is, with stored procedures, our code is stored with the data.…
- Comparing triggers, functions, and stored procedures
- Installing and configuring SQL Server
- Creating a stored procedure
- Returning data using data sets
- Creating user-defined functions
- Using "after," "instead," and nested triggers
- Modifying existing stored procedures
- Implementing logging on DELETE
- Choosing between T-SQL and CLR
- Executing a stored procedure
- Passing parameters
Skill Level Advanced
1. Getting Started
2. Installing SQL Server
Configuring your environment4m 53s
3. Stored Procedures
4. User-Defined Functions
6. Putting It All Together
7. Using CLR Assemblies
8. Exploring an ASP.NET Web Application
Next steps1m 43s
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.