Query Results?

  • How do you run a query to see results and not execute it?

  • What results are you hoping to see if you don't execute the query?

    ----------------------------------------------------------------------------------
    Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?

  • Without executing the query there is no way to see the results.

    a query must be executed for the commands to take effect.

    Is there a problem why you can not execute?

    What is the problem when executing?

  • I guess my question should have been is it possible to run a query and see results without execution. I now know its not possible but I can parse the statement to see if the syntax is correct.

    Thank you.

  • Depending on what you are using to create your query. In Query Analyzer you can highlight a specific part of the query and execute that alone. If you do not want to execute the entire thing.

    you do this by highlighting the specific part of the query and the hit F5

    This is assuming that you have sub queries....

    execute them one at a time to test them.

  • Generating and estimated execution plan is almost as good as running the code...

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.


    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply