Transact-SQL SET Commands - An Overview of the Most Commonly Used SET Commands - Video Series Video Category: Commonly Used T-SQL Constructs: Datatypes, Type Conversion, Variables, System Functions and Views and more Skill Level: 300 (Intermediate) Versions/Editions Covered: SQL Server 2005 , SQL Server 2000 , SQL Server 2008 What's funny is that most SQL programmers don't even know that there are SET commands to begin with, let alone what they're used for. Want to put yourself ahead of the pack? Watch this series and learn what SET commands are, how they are scoped and lots more good info.

Videos in this Series:

Title Skill Length Download Overview of SET Commands in Transact-SQL - What They Are, Syntax, and How to Use...   200 11 mins. Download Scoping of SET Commands - Connections, Stored Procedures, Batches and Functions   200 15 mins. Download SET Commands for Performance Tuning and Query Execution Statistics   300 21 mins. Download SET Commands for Working with NULL values   200 9 mins. Download SET Commands Often Used to Control Dates and Date Formats in Input or Export Dat...   200 10 mins. Download Using SET Commands Inside Stored Procedures and When Executing Stored Procedures   300 11 mins. Download

< Return to list of all videos

Miscellaneous Bits & Pieces:

Helpful Keyboard Shortcuts: "Windows key" - when hit by iteself the Windows key will display/hide the Start menu Helpful Keyboard Shortcuts: "CTRL" + "ALT" + "DELETE" displays the Windows Security dialog box and/or allows the user to logon Helpful Keyboard Shortcuts: "CTRL" + "Page Up" navigates forward between panes/worksheets/tabs in an application (use "Page Down" to navigate backwards)