2012年2月13日星期一

batch jobs

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

没有评论:

发表评论