SQL Server Programming and Queries Training Video: Pt. 1 - An Ove rview of the INSERT Statement in Transact SQL

Pt. 1 - An Overview of the INSERT Statement in Transact SQL - view details
This video host part 1 of the 4 part Data Manipulation Language. The INSERT STATEMENT video section and describes in detail the proper syntax and uses of the INSERT statement. An overview of this video shows the following:Proper syntax for the INSERT statementProper usage of the main uses of the INSERT statementScott overviews how to properly INSERT specific values into a table. Scott Whigham does an excellent job of showing the syntax for CREATE TABLE and an every day
common error that may happen with your code. Furthermore the video puts you in a realistic
environment with realistic errors that may happen and WHY these issues happen so you do not
repeat these issues.

NOTE: This video description was written by one of our members, Wayne Leiser. Thanks, Wayne! Source: http://www.learnitfirst.com/Course/150/Video/896/Overview-of-the-INSERT-Statement-in-Transact-SQL.aspx Course: http://www.learnitfirst.com/Course/150/SQL-2005-Programming.aspx Skill Level: 100 (Beginner) Length: 10:30 (8.13MB) Full DetailsTo download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: INSERT Statement, INSERT Syntax, INSERT, Data Manipulation Language, DML, Transact SQL, TSQL, T-SQL, TransactSQL, Transact-SQL, CREATE TABLE

This video comes from the SQL Server Programming and Queries online training course, SQL Server Programming (SQL Server 2005/2000): Transact SQL. And be sure to check out even more MSSQL Programming and Query Writing training videos.