Three Syntaxes for INSERT in T-SQL

This video is part of LearnItFirst’s Transact-SQL Programming: SQL Server 2008/R2 course. More information on this video and course is available here:

http://www.learnitfirst.com/Course161

There are three basic syntaxes for the INSERT statement. Here, trainer Scott Whigham explains each in detail and demonstrates the basics you need to know.

Highlights from this video:

– The three basic syntaxes for the INSERT statement
– VALUES
– SELECT
– EXEC
– Changes from earlier versions of SQL Server
– What happens if you leave the column list out?
– Working with a large table

and much more…