Member of the LearnItFirst.com Video Training Network Related Video Training Sites: · SQL Server DBA Tutorials · Integration Services Training
   
Transact-SQL Programming and Query Writing Training Videos
Transact SQL Videos in Series Home  Subscriber Videos  

An Overview of the INSERT Statement (Video Series)

Video Image 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:


Miscellaneous Bits & Pieces:
Security: Most DBAs prefer to remove the SQL Server login "BUILTIN\Administrators" either from the SQL Server or from the fixed server role "sysadmins" for security reasons
Badly fragmented disks can decrease input/output (IO) throughput by more than 50%
The command-line command "xcopy" has been improved to allow you to create decrypted files at the destination (hint: use the /g option)

Other Websites We Offer
LearnVBProgramming.com
Don't Forget!
Become a Guru
 
   
 
About Us Video Playback Subscriptions More Video Training More
 
© Copyright 2004-2008 LearnItFirst.com LLC. All rights reserved. All trademarks remain the property of their respective owners. This site is not affiliated in any way with the Microsoft Corporation. Refer a Friend and Get a Free Subscription!
 
1/8/2009 3:00:14 PM