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.
juniorkaAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

jogosCommented:
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)

0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Aneesh RetnakaranDatabase AdministratorCommented:
press ctrl+d  -> view result in a grid  and ctrl +T  for text

make sure that you press this before execution
0
pollock_dCommented:
go to tools > Options > Query Results > and in the drop down box select "Results to Grid"
0
ckimball99Commented:
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.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Query Syntax

From novice to tech pro — start learning today.