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 Video Tutorial	Home Subscriber Videos

Transact SQL Tutorial: Pt. 4 - INSERTs and Identity Columns: An Overview

Chapter: SELECT, INSERT, UPDATE and DELETE - Data Manipulation Language

Skill Level: 100 (Beginner)
Duration: 7:45
Size: 6.50MB
Versions/Editions Covered: SQL Server 2005 , SQL Server 2008 , SQL Server 2000
Added/Updated: Mar 20, 2007

This video hosts the final part 4 of the 4 part Data Manipulation Language INSERT STATEMENT video series and describes in detail how to properly work with IDENTITY COLUMNS. This video is a phenomenal resource of informative data that will boost your knowledge of IDENTITY COLUMNs and INSERT statements. You can expect to find information on the following topics within this video:

Proper use and explanation of IDENTITY COLUMNS
Common errors with using the INSERT statement when using Identity Columns
Working with IDENTITY INSERT ON and OFF
Introduction to SQL SERVER 2005 Specific OUTPUT inserted statment
Introduction, explanation and definition of the SCOPE_IDENTITY() function
Introduction to proper syntax for table creation
Introduction to logic warnings for usage of @@IDENTITY vs SCOPE_IDENTITY()

This video is made so that you do not even have to see the first three videos in order to follow and absorb the knowledge held within. The video is so easy to follow a caveman could do it. :D If you are looking for a reference, help or just simply need to learn about working with the IDENTITY COLUMN and INSERTS this is the video for you.

NOTE: This video was reviewed and this description was written by one of our members, Wayne Leiser. Thanks,Wayne!

Tags for this video: DML identity column insert

< Back

People Who Downloaded this Video Also Downloaded:

Title	Skill	Download
Subqueries, Nested Queries, and Derived Tables - An Introduction to Advanced SQL...	300	Download
Constraint Keys, Index Keys, Composite Keys, Natural keys, and Surrogate Keys	200	Download
Query Analyzer - Beyond the Basics (SQL Server 2000)	200	Download
When to Use HAVING Instead of WHERE - Aggregates, GROUP BY, and the HAVING Claus...	300	Download
JOINs and UNIONs - How Do I Know When to Use a JOIN or a UNION?	300	Download

This video is part of the following video series: "An Overview of the INSERT Statement"

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()

To view all videos in this series, click here

About the Instructor:

Scott Whigham is the founder of LearnItFirst.com, one of the web's most extensive video training libraries focusing on technical training. Scott is also an experienced consultant, trainer, and author with more than a decade of hands-on experience working with SQL Server databases, writing and debugging applications using Visual Studio, and performance tuning. Scott designed the architecture (websites, class libraries, and database) for the LearnItFirst.com websites and, most re... (Scott Whigham's full bio can be found on the About the Author page)

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