SQL Server: Batches

 SQL Server     sbo     Updated on Dec 15, 2013     VIKRAM     402   

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

 

  Related Articles
SQL Server: Variables
SQL Server: Triggers
SQL Server: Difference between Stored Procedure and Function
SQL Server: Functions
SQL Server: Named Batches
SQL Server: Anonymous Batches
SQL Server: Differences between CHAR, NCHAR, VARCHAR and NVARCHAR
SQL Server: System Databases
SQL Server: Insert values into Identity Column
ASP.Net: List View Basic Example
  Recent Articles
SQL Server: Variables
SQL Server: Triggers
SQL Server: Difference between Stored Procedure and Function
SQL Server: Functions
SQL Server: Named Batches
SQL Server: Anonymous Batches
SQL Server: Differences between CHAR, NCHAR, VARCHAR and NVARCHAR
SQL Server: System Databases
SQL Server: Insert values into Identity Column
ASP.Net: List View Basic Example