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

< Return to list of all videos

Miscellaneous Bits & Pieces:

The command-line command "xcopy" has been improved to allow you to create decrypted files at the destination (hint: use the /g option) Most SQL Server adminstrators prefer to change the port of a default instance from 1433 to something unused. This prevents hackers and malicious software from connecting to port 1433 and locating a SQL Server. Bottom line: everyone knows that the default SQL Server port is 1433 so, to create a secure server, change the port number Helpful Keyboard Shortcuts: "Windows key" - when hit by iteself the Windows key will display/hide the Start menu