question

jamesbond avatar image
jamesbond asked

how to remove coloum name from the dispaly result

need to display output without coloum name
t-sql
3 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.

Mrs_Fatherjack avatar image Mrs_Fatherjack commented ·
Can you show us what you have written so far?
2 Likes 2 ·
nidheesh.r.pillai avatar image nidheesh.r.pillai commented ·
Honestly, what is the use of such a display where there in no column name? How will you differentiate or classify data?
1 Like 1 ·
ThomasRushton avatar image ThomasRushton ♦♦ commented ·
Alternatively, how does your client code access the data? Seriously, this sounds more the sort of thing that should be dealt with at the presentation layer of the application, rather than at the data end...
0 Likes 0 ·

1 Answer

·
eaglescout avatar image
eaglescout answered
If you are wanting to see a column value without the column name associated with it, then you can use AS to change that column name to something like Misc., Blank, etc. Example: Select (Your ColumnName) AS (Anything you wish) Hopefully that helps!
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.