Using the OUTPUT Clause With the INSERT, UPDATE, and DELETE Statement - Video Series Video Category: SELECT, INSERT, UPDATE and DELETE - Data Manipulation Language Skill Level: 300 (Intermediate) Versions/Editions Covered: SQL Server 2005 , SQL Server 2000 , SQL Server 2008 SQL Server 2005 introduced the OUTPUT and INPUT clauses as optional clauses for hte INSERT, UPDATE, and DELETE statements. This series shows you how to use each, when to use each, and gives you ideas on how to make the most of these new features in SQL Server 2005 and SQL Server 2008.

Videos in this Series:

Title Skill Length Download Pt. 1 - Using the OUTPUT Clause with the INSERT, UPDATE and DELETE Statements   300 9 mins. Download Pt. 2 - Using the INPUT Clause with the OUTPUT Clause   400 8 mins. Download

< Return to list of all videos

Miscellaneous Bits & Pieces:

Keyboard Shortcut for SQL Server Management Studio: CTRL+SHIFT+U converts text to uppercase The command-line command "netstat" can show you active connections, TCP port usage, network statistics and more Security Tip: Protect your "sa" account by using a very strong password. Hackers can issue dictionary attacks against your SQL Server and attempt to guess your "sa" password with brute force. By providing a password that (a) cannot be found in any dictionary, and (b) contains letters, numbers, and special characters, you give yourself maximum password protection