Join Martin Guidry for an in-depth discussion in this video Executing a stored procedure, part of SQL Server: Triggers, Stored Procedures, and Functions.
Now I'd like to go ahead and implement the functionality that will call a…stored procedure and display data on the screen.…Here we can see we have a space available for a list of active authors.…So first let's write a stored procedure that returns all the active authors and…then we'll connect that to the web page.…I have some code prepared in the exercise files.…And it's a very simple stored procedure that selects store from the Authors…table where Active equals 1. So that would be all of our active authors. That looks good!…Going back to Visual Studio, I'll insert my cursor into the appropriate table…cell, and off the toolbox I want find the Data section.…
So I'll scroll down a little and underneath the Data section there is a GridView.…I'll drag our GridView over and it's asking me a few questions; one of them,…what is my Data Source, and currently it's None.…I'll create a new Data Source.…I want that to be a SQL Server data source.…We created the connection a few videos back, so now we have the option to…
- 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.