I'm looking for the definition of a batch job, what is it? How is it run? How does it differ from other jobs?
thx,
Kat
|||If i remember right
in query analyzer, a batch is a series of tsql statement
separated by keyword Go
select * from table1
select * from table 2
go
select * from table3
select * from table4
this query consist of two batch
batch as compared to stored procedure
is characterized by many roundtrips to the server
as compared to one round trip in SP
SP is enjoy cached execution as compared to
several process of parsing, compiling,optimizing and executing
a batch process
没有评论:
发表评论