In this article i will explain about Batches in SQL Server.
A batch is a group of sql statements. Which are executed as unit. Two types of batches are there.
A group of statements which can't be reffered by a name. Then that group/batch is called Anonymous Batches.
2. Named Batches:
A group of statements which can be reffered by a name. Then that group/batch is called Named Batches. Three types of Named Batches are there.
a. Stored Procedures