What is Batch and types of Batches in SQL Server?

 Updated on October 28, 2014     VIKRAM     611

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 BatchesThree types of Named Batches are there.

a. Stored Procedures

b. Functions

c. Triggers

If you enjoyed this post, please like (or) share this article.


Comments