SQL - displaying query results in Microsoft SQL Server

How can I display results of my SQL queries in a grid/table in Microsoft SQL Server?

Just started out playing around with SQL, and doing some inner joins, and don't know how to display results into a grid/table after I run the queries.
Who is Participating?
jogosConnect With a Mentor Commented:
In SQL2000- > tool query analyser
In SQL2005 -> tool Management studion (New query)

In both teher is a menu option 'Query' where you can choose, query to text, query to grid or file

(In Tools/options you can set your preference)

Aneesh RetnakaranDatabase AdministratorCommented:
press ctrl+d  -> view result in a grid  and ctrl +T  for text

make sure that you press this before execution
go to tools > Options > Query Results > and in the drop down box select "Results to Grid"
If you are using SQL Query Analyzer, you can change how your output is presented in the Query toolbar menu.  There are three options: Results in Text, Results in Grid and Results to File.

If you are using SQL Server Managment Studio, you change how your output is presented in the Query toolbar menu under the Results To section.  You have the same three options as above.
All Courses

From novice to tech pro — start learning today.