SQL Server 2008: How to show results all at once after query ends?

Question

Hello,

I want to ask if there is a way to show results (all at once) just after the query ends execution? In other words, I dont want to see "Partial" records on the way of query execution.

Thank you.

Answer 1

Would wrapping your SQL statements into a single transaction help?