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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-01-01 : 20:15:44
|
Joe writes "I was wondering if there was a way to remove the name of the columns from your query results. Something similiar to SET NOCOUNT ON
I am using SQL 7 and winNT / 2000 with the latest SP..
example:
Select * from query
results =
ID NAME EMAIL
1 Joe Joe@mail.com
2 Joe Joe@mail.com
I would like just:
1 Joe Joe@mail.com
2 Joe Joe@mail.com
Thanks for the help in advance." |
|
|
scottpt
Posting Yak Master
186 Posts |
Posted - 2003-04-28 : 10:57:58
|
| How so you remove them from query analyzer? The reason for this is I want to creat a sql statement then cut and paste, bu I can't do it because of the "--------------". I don't want to have to creat a cursor just to print out a line I have already created. |
 |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-04-28 : 11:52:50
|
| Why not just change to grid form (unless you're <SQL2000)And what's with the big deal about cutting and pasting anyway? Just don't copy those lines...Brett8-) |
|
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2003-04-28 : 12:07:29
|
| SQL2000 QA - Tools>Options>Results untick Print column headersHTHJasper Smith0x73656c6563742027546f6f206d7563682074696d65206f6e20796f75722068616e6473203f27 |
|
|
|
|
|
|
Remove Headers?