An Overview of the INSERT Statement - Video Series Video Category: SELECT, INSERT, UPDATE and DELETE - Data Manipulation Language Skill Level: 100 (Beginner) Versions/Editions Covered: SQL Server 2005 , SQL Server 2000 , SQL Server 2008 This video series describes in detail the proper syntax and uses of the INSERT statement, the INSERT with VALUES and EXEC. This series also touches base with the COUNT statement and a realistic environmental use of that. Furthermore you will be properly introduced to writing, executing and altering stored procedures; (CREATE PROC), (ALTER PROC), (EXEC PROC) with an integration of IF and ELSE T-SQL statements. Highlights: Proper usage of the main uses of the INSERT statement Utilizing CHECK CONSTRAINTS Real life examples when working with INSERTS and CONSTRAINTS Proper use and explanation of IDENTITY COLUMNS Introduction to logic warnings for usage of @@IDENTITY vs SCOPE_IDENTITY()

Videos in this Series:

Title Skill Length Download Pt. 1 - An Overview of the INSERT Statement in Transact SQL   100 11 mins. Download Pt. 2 - Discussion of the Various Syntaxes for the INSERT Statement   100 11 mins. Download Pt. 3 - Inserting Data Into Tables With Constraints   100 11 mins. Download Pt. 4 - INSERTs and Identity Columns: An Overview   100 8 mins. Download

< Return to list of all videos

Miscellaneous Bits & Pieces:

Helpful Keyboard Shortcuts: "CTRL" + "Page Up" navigates forward between panes/worksheets/tabs in an application (use "Page Down" to navigate backwards) Book You Should Probably Own: Ken Henderson's "The Guru's Guide to SQL Server Stored Procedures, XML, and HTML" After SQL Server 2000 you should not be using @@IDENTITY in your code. Microsoft replaced @@IDENTITY with SCOPE_IDENTITY() in SQL Server 2000