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
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
Miscellaneous Bits & Pieces:
Did you know that the database role "ddladmin" can TRUNCATE the table (delete all rows) but not SELECT?
Helpful Keyboard Shortcuts: "CTRL" + "SHIFT" highlights a block of text when used with the arrow keys
Helpful Keyboard Shortcuts: "Windows key" - when hit by iteself the Windows key will display/hide the Start menu
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 8:39:07 AM