akberali67 (3/18/2013)

---

Hi,

I have a query window with a lot of code but I do not want to run it entirely in error, is there something I can place in the beginning of the code that will throw me a message?

Thanks,
Akber.

RAISERROR ('Return message immidiately', 10,1) WITH NOWAIT;

akberali67 (3/18/2013)

---

Hi,

I have a query window with a lot of code but I do not want to run it entirely in error, is there something I can place in the beginning of the code that will throw me a message?

Thanks,
Akber.

SELECT * FROM Table_That_Does_Not_Exist

sestell1 (3/18/2013)

---

The easiest thing to put at the top would be a simple select query referencing a table that does not exist.
Something like

SELECT * FROM Table_That_Does_Not_Exist

.

CapnHector (3/18/2013)

---

I always use a close parentheses ")" at the top of my code sheets (be careful if you add a go it may not work exactly, tend not to break any thing into batches except in roll out scripts.) This generates a parse error and stops the batch from running.

sestell1 (3/19/2013)

---

Simple and effective, I like it!

RAISERROR ('Stop here',20,1) WITH LOG