Join Martin Guidry for an in-depth discussion in this video Passing parameters, part of SQL Server: Triggers Stored Procedures and Functions.
Now it's time to implement the functionality that will allow the user to…insert a new author.…In order to do this, we'll have to get our web page to accept some input and…then pass that input as parameters to a stored procedure.…First let's create the stored procedure that expects the parameters.…I have pre-staged a stored procedure.…We'll go ahead and look at that code.…The procedure's name is InsertNewAuthor and accepts two parameters, a firstName…parameter and a lastName parameter, and then it executes a simple INSERT…statement, inserted into the Authors table, FirstName LastName and the Active…status of 1. Command(s) completed successfully. That looks good.…
Now back on our web page, I'll insert my cursor into the blank area under insert…new author, and I'm going to type the phrase FirstName and then, I'll drag a text…box from the Toolbox that will be used to insert the FirstName.…I'll then put a hard Return after that and type LastName, drag another…textbox, and then under all that, we'll want a single button that will cause…
- 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.