Before I get into my demonstrations, I'd like to help you set up a…development environment very similar to what I'm using so you can perform…these steps at home.…We are going to be using two products:…Microsoft SQL Server 2012 Express Edition and Microsoft Visual Web Developer…2010 Express Edition.…First let's look at SQL Server 2012 Express Edition.…You can find that add the URL www.microsoft.com/express/database.…
This takes me to the standard landing page for SQL Server Express Edition.…I have a big red button in the middle of the screen.…I'll click on that and it shows me some different choices.…You definitely want to get one of the versions that has the database engine and…the tools include Sequels Server Management Studio which is an important tool…in many of our demos.…So I'm going to with the top one here.…That takes me to another page where I'll select the 64-bit edition Express with Tools.…
Now that we've downloaded SQL Server 2012 Express Edition let's go ahead and install it.…So in this interface I want the top option New SQL Server stand-alone…
Author
Martin Guidry
Released
9/24/2012- 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
Duration
Views
-
Introduction
-
Welcome47s
-
-
1. Getting Started
-
Why use a stored procedure?4m 59s
-
Why use functions?1m 27s
-
Why use triggers?1m 10s
-
2. Installing SQL Server
-
Configuring your environment4m 53s
-
-
3. Stored Procedures
-
Creating a stored procedure2m 46s
-
Modifying a stored procedure2m 34s
-
Returning data using cursors3m 45s
-
Using transactions2m 47s
-
-
4. User-Defined Functions
-
5. Triggers
-
Using "after" triggers3m 47s
-
Using nested triggers1m 38s
-
-
6. Putting It All Together
-
7. Using CLR Assemblies
-
8. Exploring an ASP.NET Web Application
-
Passing parameters3m 41s
-
Getting return values2m 53s
-
Conclusion
-
Next steps1m 43s
-
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press 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.
Share this video
Embed this video
Video: Configuring your environment