SQL Server 2005: Query window in Microsoft SQL Server Management Studio

The query window has  a lot more to offer than just outputting the results to grid.  You can also output the results in text format and also save the results to a file.  If you are in the query window, you may notice an additional toolbar on top of it similar to the one below:

There are 3 buttons there that let you specify how you want your output from the query.  They are Results to Text, Results to Grid, and Results to File respectively:

You can also display the estimated execution plan for your query by clicking the following button:

*

You can also include the actual execution plan by clicking the following button before you execute your query:

*

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s