Member of the LearnItFirst.com Video Training Network Related Video Training Sites: · SQL Server DBA Tutorials · Integration Services Training
     
Transact SQL Training Videos             * SQL Server DBA Tutorials
* Integration Services Training
* More Videobooks...
Email
Password
Register
LearnTransactSQL.com Subscriber Videos
Transact SQL Videos By Category Home  Subscriber Videos  
Stored Procedure Programming, Error Handling, and Passing Resultsets to the Client - Video Category (all video categories)
Video Image Modern-day programming demands security and secure coding. If you are embedding your SQL inside the application (i.e., writing a SELECT/INSERT in the form itself) then the argument is often made that you are not writing secure or reusable code - both terrible things in today's environment. Check out these videos for more information on SQL Server stored procedure programming.

Versions/Editions Covered: SQL Server 2000
Videos in this Category: orange = video series 
blue = individual video 
Click "Download" to download the video or click the video title for more information
TitleSkillView / DownloadLength
Series (2 videos) - Using Output Parameters in Your SQL Server Stored Procedures   300 (Click for Videos) 19 mins.
Series (3 videos) - Return Values and SQL Server Stored Procedures   200 (Click for Videos) 28 mins.
Series (5 videos) - Stored Procedures - An Introduction to Syntax, Concepts and ...   200 (Click for Videos) 78 mins.
Customizing SQL Server with International Error Messages and How SQL Server 2000...   400 Download 8 mins.
RAISERROR and Substitution Parameters - How to Customize Your Error Messages (SQ...   200 Download 12 mins.
Stored Procedure Introduction: Definition, Usage, and Creating Stored Procedures...   100 Download 16 mins.
Over 2 hours of Transact SQL tutorials in this category
< Return to list of all videos
Miscellaneous Bits & Pieces:
Book You Should Probably Own: Michael Hernandez's "Database Design for Mere Mortals"
What query would return the first day of this month? SELECT DATENAME(dw, DATEADD(dd, - DATEPART(dd, GETDATE()) + 1, GETDATE())) AS FirstDay
Performance Tip: Deadlocks are the bane of SQL programmers but can often be avoided by savvy programming. One technique you can use to minimize deadlocks is to use SET DEADLOCK_PRIORITY LOW for one transaction. When a deadlock is encountered SQL Server will rollback this transaction and allow the other transaction to finish it's work
Video search
Company News
SSRS tutorials
     
Home | About Us | Advertising | Become an Author | Contact Us | Privacy | System Req's | Terms | Testimonials | Work for Us! | Blogs | Site Map Refer a Friend and Get a Free Subscription!
© Copyright 2004-2008 LearnItFirst.com LLC. All rights reserved. All trademarks remain the property of their respective owners.
This site is not affiliated in any way with the Microsoft Corporation.
8/7/2008 6:44:01 PM