No of queries in Batch

  • Thread starter Thread starter DOTNET
  • Start date Start date
D

DOTNET

Is there any limitition in no of queries, in stored procedure when we are
working with batch queries? If so how many queries we can create in batch?

--
Thanks and Regards,

Senthil Kumar M.

Cycus Technologies Pvt Ltd
R-501, Remi Bizcourt
Shah Industrial Estate
Off Veera Desai Road
Andheri(W),Mumbai 400 049, India
Tel: +91-22-5675-6612/13
Mobile: +91-98 197 21911
Fax: +91-22-5675-6249
E-mail: (e-mail address removed)
http://www.cycustech.com
 
you can put lots and lots of sql statements into a batch

you typically seperate them with a GO statement; right??

i've seen thousands of items in a script before; i mean.. thousands of
views and sprocs.. those counts aren't event remotely possible via MDB

thank goodness for ADP!

-aaron
 
Back
Top