Basics of Transact-SQL: Batches, Scripts, GO, and Statements

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 Here, you will look at some T-SQL fundamentals. Trainer Scott Whigham focuses in on the details of batches, scripts, GO, and statements, covering all of the basic knowledge you will need to understand these concepts. Some of it may be familiar to you if you've worked with any sort of scripts before. What happens if you put "GO" in the wrong place? What is a batch? This video contains a few examples using SQL statements to get you started. Highlights from this video: - Review of what an SQL script is - What is a statement terminator? - Executing every statement or specific statements in a file - Using the Parse command and much more...