Member of the
LearnItFirst.com Video Training Network
Related Video Training Sites:
·
SQL Server DBA Tutorials
·
Integration Services Training
Create a free account
·
Sign In
Transact SQL Videos in Series
Home
Subscriber Videos
Control-of-Flow Language in Transact-SQL (Video Series)
Video Category:
Commonly Used T-SQL Constructs: Datatypes, Type Conversion, Variables, System Functions and Views and more
Skill Level:
200 (Beginner - Intermediate)
Versions/Editions Covered:
SQL Server 2005
,
SQL Server 2000
,
SQL Server 2008
IF, WHILE, GOTO, BEGIN/END and other oft-used SQL statements are looked at in detail in this series on query execution.
Videos in this Series:
Title
Skill
Length
Download
Part 1 - Introduction to Using Control-of-Flow Language in Your SQL
200
8 mins.
Download
Part 2 - Using IF Statements to Control Execution in Scripts and Stored Procedur...
300
17 mins.
Download
Part 3 - GOTO Statements and When and How to Use Them
200
12 mins.
Download
Part 4 - Using EXISTS to Control Execution In an IF Statement
300
14 mins.
Download
Part 5 - WHILE Loops and Implementing Looping Structure in SQL
400
18 mins.
Download
Miscellaneous Bits & Pieces:
NTFS file and folder compression is not compatible with EFS - Encrypting File System. You can either compress or encrypt but not both
Running "MMC" from the command prompt brings up the Microsoft Management Console (MMC) tool and allows you to create your own custom MMCs
Security: Most DBAs prefer to remove the SQL Server login "BUILTIN\Administrators" either from the SQL Server or from the fixed server role "sysadmins" for security reasons
About Us
·
Corporate Philosophy
·
Advertise With Us
·
Become an Author
·
Contact Us
Video Playback
·
System Requirements
·
TSCC Codec
(to play videos)
·
Troubleshooting/Problems
Subscriptions
·
Pricing/Buy Now
·
Testimonials
·
Privacy
·
Terms of Service
More Video Training
·
SQL Server DBA Tutorials
·
Integration Services Training
·
All of Our Websites
More
·
FAQs
·
Search for videos
·
Site Map
© 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.
9/8/2008 9:02:31 AM