Hi,

If I put a bunch of commands (insert into..., update table... x 10, drop
table.....) wil the server then first check the whole syntax before it
excecutes or will it just start and hold on error?

It's not like I'm gonna send wrong code, but in case during transmission to
the server the data gets corrupted.

rg,
Eric

In SSMS there is a Parse icon (or from the Query menu -> Parse, or Ctrl+F5) which will only parse and check the SQL.

--
Plamen Ratchev
http://www.SQLStudio.com

Eric wrote:
I imagine it would just go top-down. Is that a transaction I smell?

--
Ray Marron

On Oct 8, 3:36*pm, Eric <E... (AT) discussions (DOT) microsoft.com> wrote:
Check the whole script compiles using the "blue tickmark" button
before you exec

For each batch, it'll check the syntax first and then execute the batch. A
syntax error in one batch does not prevent SQL Server from executing the next
batch.

Linchi

"Eric" wrote: