How to Use Query Batch in T-SQL
Query Batch is a group of one or more Transact-SQL statements sent at the same time from an application to SQL Server for execution
T-SQL (Transact SQL) is a proprietary SQL extension used by Microsoft SQL Server and Sybase SQL Server. T-SQL adds extensions for procedural programming. Transaction-SQL is an extended form of SQL that adds declared variables, transaction control, error and exception handling and row processing to SQL's existing functions. Microsoft SQL and Sybase both support T-SQL statements It is largely SQL-92 compliant, so if you're familiar with another vendor's flavor of SQL, you'll probably feel right at home with Transact-SQL.
Query Batch
A batch is a group of one or more Transact-SQL statements sent at the same time from an application to SQL Server for execution. The most important characteristic of a batch is that it is parsed and executed on the server as an undivided entity. In some cases, batches are created implicitly. SQL Server compiles the statements of a batch into a single executable unit, called an execution plan. The statements in the execution plan are then executed one at a time.
The given below example shows how to execute query batch:-
Example:
1> create table workers(
2> ID int,
3> name nvarchar (20),
4> salary int,
5> start_date datetime,
6> city nvarchar (20),
7> region char (5))
8> GO
1>
2> --Inserting Records in a Query Batch
3>
4> SET QUOTED_IDENTIFIER OFF
5> GO
1> INSERT INTO workers (ID, Name) VALUES(01,"Ravi")
2> INSERT INTO workers (ID, Name) VALUES(02,"sapna")
3> INSERT INTO workers (ID, Name) VALUES(03,"Pankaj")
4> INSERT INTO workers (ID, Name) VALUES(04,"Udas")
5> GO
(1 rows affected)
(1 rows affected)
(1 rows affected)
(1 rows affected)
1>
2> select * from workers
3> GO
ID name salary start_date city region
----- ---------- ----------- ------------- ---------- -------
01 Ravi NULL NULL NULL NULL
02 sapna NULL NULL NULL NULL
03 Pankaj NULL NULL NULL NULL
04 Udas NULL NULL NULL NULL
(3 rows affected)
Happy Learning