Query Results?

Question

Query Results?

Janet Batts

SSC Rookie

Points: 42
More actions
November 14, 2007 at 7:32 pm

#95536

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

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

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

Matt Miller (4) SSC Guru Points: 124210 More actions · Answer 1

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?

Alex Cooper SSC-Addicted Points: 499 More actions · Answer 2

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?

Janet Batts SSC Rookie Points: 42 More actions · Answer 3

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.

Alex Cooper SSC-Addicted Points: 499 More actions · Answer 4

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.

Jeff Moden SSC Guru Points: 1004279 More actions · Answer 5

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)