Sunday, April 9, 2017

Different Options for Query Results in SQL Server


SQL server provides different options to display query results. By default, it gives the results in grid format. As per the requirement, user can change the default options from the tools menu.

1.    Results to Text
2.    Results to Grid
3.    Results to File



Results to Text:



Results to Grid:



Results to File:



Steps to change query results options:

Follow the below steps to change the default options:


1. Under Tools menu à click Options as shown below.



2. In the Options dialog box, expand Query Results, expand SQL Server and then select General as shown below. Select the desired option and click Ok to save.




Share This
Previous Post
Next Post

TekGrabs, established in 2017, is in the business of sharing Information. It provides news, articles and photos about the different technologies, inventions in different domains. Provides information on programming and databases.

0 comments: