PDA

View Full Version : SQL script order



Thiyagu
07-05-2005, 04:03 PM
Hi,
Can any one tell me in which order SQL scripts are executed with in a connection? It is not executing in the same order as I added.

Thanks,
Thiyagu

chrishein
07-06-2005, 10:55 AM
I believe what you need to do in order to ensure order is activate Batch mode. This can be done by right clicking on the SQL Scripts in the middle panel and selecting Batch Mode. This will ensure that the scripts from the top down.

Hope that helps,
Chris

Thiyagu
07-06-2005, 05:52 PM
Thank you, Chris,
It solves my issue.
Can you please tell me when we set batch mode, apart from running the scripts in order, what other changes happpen comparing to normal mode?

Cheers,
Thiyagu