What are the different types of Batches in SQL Server?

Introduction:

In this article i will explain about Batches in SQL Server.

Description:

In previous articles i explained what are joins, and different types of joins. Now i will explain about Batches in SQL Server.

Batches:

A batch is a group of sql statements. Which are executed as unit. Two types of batches are there.

1. Anonymous Batches:

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