question

manoj123 avatar image
manoj123 asked

How to display select statement without column name

`Hi I have to display the result of query without column header. for example select * from table gives o/p like col1 col2 value1 value2 value3 value4 I want to get result just values not the column name value1 value2 value3 value4 I know there is option from changing query option uncheking include column header in the result set . How can this setting applied progarmatically from t-sql Thanks in advance
query-results
2 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

ThomasRushton avatar image ThomasRushton ♦♦ commented ·
Again, this seems like something that should be done at the presentation layer rather than at the SQL Server layer.
1 Like 1 ·
Grant Fritchey avatar image Grant Fritchey ♦♦ commented ·
If one of the answers below is helpful, please indicate this by clicking on the thumbs up next to it. If one of the answers below solved your problem, please indicate this by clicking on the check box next to it.
1 Like 1 ·
eghetto avatar image
eghetto answered
see here: [Results with no column headers][1] [1]: http://www.sqlservercentral.com/Forums/FindPost1318506.aspx
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Scot Hauder avatar image
Scot Hauder answered
SELECT col1 [ ], col2 [ ] FROM table
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.