Join Martin Guidry for an in-depth discussion in this video Exploring a real-world INSERT procedure, part of SQL Server: Triggers Stored Procedures and Functions.
Now I'd like to demonstrate some more complex stored procedures.…These are the types of procedures I commonly see on large databases in the real world.…They implement business rules as well as enforce data integrity requirements.…In order to execute the examples in this section we'll need a new table.…I have a text file of data in your folder of exercise files.…Let's import that data now.…I'll right-click on myDatabase, go to Tasks, and near the bottom we have Import Data.…On this screen I'll click Next.…
The first question it asked me is, what's my data source?…My data source will be a Flat File and I'll browse to that file now.…It's in the Chapter 6 section of your exercise files.…This dialog box defaults to text files.…What I want is want is actually a CSV, so there we will pick up students.csv,…and now it's just a whole bunch of Next, Next, Next, Next, Finish.…And I get a bunch of green check mark saying Success. That seems good.…
I'll hit a refresh here and I have a new students table.…
- 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.