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.
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
-
CreatedDec 15, 2013
-
UpdatedNov 03, 2020
-
Views1,759
Related Articles
Different types of variables in SQL Server
What is Cross Join in SQL Server
How delete record from parent table when there is Foreign Key relation in SQL Server
What is the differences between CHAR, NCHAR, VARCHAR and NVARCHAR in SQL Server?
How to add or remove a column from a table in SQL Server?
How to insert values into Identity Column in SQL Server?
How to get a fixed-length value in SQL Server?
What is Left Join (or) Left Outer Join in SQL Server?
How to get current week dates in SQL Server?
What are the different types of Date formats in SQL Server?