Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Select question

Author  Topic 

mikeym
Starting Member

1 Post

Posted - 2010-01-16 : 18:07:44
At work we have server 2005 STD sql. And at home I just downloaded a trial of sql 2008. Over all they seem pretty similar but I hate the way 2008 display its query syntax when you select all rows from a table I just want the * to be displayed not all the column names. It’s not that big of a deal just annoying. Is there a way to simplify this were it displays only the *.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-01-16 : 19:39:49
Just type it into a new query window rather than using the GUI sql builder.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."
Go to Top of Page
   

- Advertisement -