Member of the LearnItFirst.com Video Training Network Related Video Training Sites: · SQL DTS Training Videos · SQL Programming Videos
     
SQL Server 2000 Training Videos             * SQL DTS Training Videos
* SQL Programming Videos
* More Videobooks...
Email
Password
Register
LearnSqlServer2000.com Subscriber Videos
SQL Server 2000 Videos By Category Home  Subscriber Videos  
TSQL Programming: Stored Procedures, Variables, Functions and Triggers - Video Category (all video categories)
Video Image This category of videos is all about stored procedure programming, Error Handling, and passing resultsets to the client by various means as well as writing triggers (AFTER/INSTEAD OF), functions (scalar and table-valued UDFs), and TSQL variables.


Versions/Editions Covered: SQL Server 2005 , SQL Server 2000 , SQL Server 2008
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 (5 videos) - Stored Procedures - An Introduction to Syntax, Concepts and ...   200 (Click for Videos) 78 mins.
Variables and Scoping - Local Variables and Batch Terminators   200 Download 8 mins.
Why You Use SCOPE_IDENTITY() Instead of @@IDENTITY   300 Download 12 mins.
< Return to list of all videos
Miscellaneous Bits & Pieces:
The "SQL Server 2000 Resource Kit" features a fantastic System Tables map that describes each system table, its columns, and their usage
What query would return the first day of this month? SELECT DATENAME(dw, DATEADD(dd, - DATEPART(dd, GETDATE()) + 1, GETDATE())) AS FirstDay
The command-line command "ipconfig" is an essential tool for all Windows sysadmins. It allows you to view network adapter information such as IP, DNS, gateways and much more
Video search
Company News
Visual Basic 2005/2008 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.
7/3/2008 6:28:06 PM