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  
Commonly Used T-SQL Constructs: Datatypes, Type Conversion, Variables, System Functions and Views and more - Video Category (all video categories)
Video Image This category is sort of a "catch-all" for commonly used features in SQL such as the IF statement, CASE, EXISTS, and working with global variables among other things. Put it this way: if you're a SQL programmer, you work with these every day so you might as well learn about them here!

Versions/Editions Covered: SQL Server 2005 , SQL Server 2000 , SQL Server 2008 , SQL Server - All Versions
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) - Control-of-Flow Language in Transact-SQL   200 (Click for Videos) 69 mins.
Series (6 videos) - Transact-SQL SET Commands - An Overview of the Most Commonly...   300 (Click for Videos) 76 mins.
DATETIME and SMALLDATETIME - Working with Dates and Times SQL Server   200 Download 15 mins.
Extended Properties in SQL Server 2000 - What They Are and How to Use Them to Ge...   300 Download 10 mins.
TOP Operator: What's New and Why Life Is much Easier Today   200 Download 13 mins.
Variables - Understanding the Difference Between Using SET and SELECT to Assign ...   200 Download 11 mins.
Variables and Scoping - Local Variables and Batch Terminators   200 Download 8 mins.
What is Context_Info?   New! 200 Download 8 mins.
Over 3 hours of Transact SQL tutorials in this category
< Return to list of all videos
Miscellaneous Bits & Pieces:
It is very easy to disable a trigger: ALTER TABLE MyTable DISABLE TRIGGER MyTrigger. If you want to disable all triggers for a table just replace the trigger name with the word ALL. To re-enable the triggers just replace DISABLE with ENABLE
Badly fragmented disks can decrease input/output (IO) throughput by more than 50%
Keyboard Shortcut for SQL Server Management Studio: CTRL+SHIFT+U converts text to uppercase
Video search
Company News
T-SQL Training Videos
     
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:41:33 PM