What is Batch and types of Batches in SQL Server?
Batches:
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
b. Functions
c. Triggers