Home Forums SQL Server 2008 T-SQL (SS2K8) Stop large queries from running RE: Stop large queries from running

  • March 18, 2013 at 2:21 pm

    #1598165

    sestell1 (3/18/2013)

    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.

    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.

    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.

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]