batch in SQL Server

Question

what is batch in SQL Server and where we can use it ?

Vilas Gite · Answer

Hi Gurjeet SQL Batch definition : Batch is an collections of T-SQL(T-SQL is database language) Statements. There are two types of Batches : 1) Anonymous batches 2) Named batches. 1) Anonymous Batches : Anonymous batch have no name only T- SQL statements. (Batch without name). Syntax : Begin -------Statements----- ---------Statements----- End 2) Named Batches : Named batches dived into 3 types. i) Stored Procedures ii) Functions iii) Triggers. ------------------------------------------------------------------------ If this reply solve your post…then " MARK AS ANSWER "!

Vilas Gite · Answer

See More for Perfect: Batch Definition and Rules : http://msdn.microsoft.com/en-us/library/ms175502.aspx Batch Example ( How to use) : http://msdn.microsoft.com/en-us/library/aa212832(SQL.80).aspx ------------------------------------------------------------------------------------------------------------------ If this reply solve your post…then " MARK AS ANSWER "!

batch in SQL Server

Answers (2)