VCS2010_08_02 – Basics of Creating, Calling and Managing Stored Procedures
As the title suggests we spend twenty minutes on the basics of creating stored procedures including basic syntax, using the built-in templates (in case you can’t remember all that syntax off the top of your head). We briefly discuss the BEGIN and END keywords in SQL as what defines code blocks in T-SQL. Next, I demonstrate executing Stored Procedures in a new query window using an ad hoc query. I discuss how to create scripts that ALTER and DROP stored procedures. I spend a few moments talking about “scripting” your database objects and changes and why that is an important skill … namely, to allow the migration of your database from a development to a production environment, tweakability, and source / version control. Finally I discuss naming conventions for Stored Procedures.
This is a short preview that demonstrates the quality of the screencasts we offer at LearnVisualStudio.NET.
Scroll down and click the play button in the lower-left hand corner of the video player to start watching.
The full length video is 21 Minutes, 49 Seconds and is available to LearnVisualStudio.NET members. Join today!
Bob, we love the videos – good presentation & pace. They’re a great way to help beginners get up to speed quickly.Mark Jewett , Senior Manager
SQL Server, Microsoft Corporation
1 Year Membership
$75per year
(it’s about $6 a month)
- Watch hundreds of screencasts
- New training each week
- Stream instantly via Vimeo … even works on iOS (and *some* Android devices)!
- Download source code
Lifetime Membership
$200pay just once
keep learning new .NET stuff
- 1 Year benefits, plus …
- Download video files to keep. Powered by Amazon S3 (blazing fast).
- Q & A Get answers to your questions about the videos