Working with Batches - T-SQL Step by Step Course - Lesson 33 | SQL courses

Duration: 18:33 min

Summary: In this video, we will discuss about batches. A batch is a one or more T-SQL statements sent by a client application to SQL Server for execution. It is different from transactions because a batch can have multiple transactions, and a transaction can be submitted in parts as multiple batches. We will discuss how a batch will not execute when it has syntax errors, and we will also talk about using variables in batches. Then we will discuss the statements that cannot be combined in the same batch, and how the checking for the existence of objects and columns happens at the batch level.