Join Martin Guidry for an in-depth discussion in this video Downloading and installing a sample database, part of SQL Server: Triggers Stored Procedures and Functions.
Now that we've installed SQL Server let's go ahead and set up a test database…to run some demos on.…I've already staged some code for you in your Exercise Files folder.…The one says create_database, just copy and paste all of that into Management Studio.…You notice near the top it's going to try to create some files in C:\program…files\Microsoft SQL Server, et cetera, et cetera.…This is the default path for database and log files.…
You're welcome to use a different path if you want to.…What I have on the screen here just represents the default.…So we'll go ahead and run that.…Command completed successfully.…And that gives us a new database called myDatabase.…We do need to add one table to that database and populate it with just a…little bit of data.…We have script for that also.…So again I'll copy and paste that over, and execute, and we see now we have an…Authors table and we should have of a few records in that Authors table. It looks good.…
I think we're ready to go.…
- 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.