Result without header

WeTi
WeTi used Ask the Experts™
on
Dear expert

I would like to in MSSQL server query result shows without header. I would not like to change any settings. I just want to show some result without header. Not all of them.

Possible?
Thx
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Senior .Net Consultant
Top Expert 2016
Commented:
you can "hide" the header by setting a blank alias:

select f1 as ' ', f2 as ' ', f3 as ' ' from YourTableName

Open in new window

Author

Commented:
worked thx
Mark WillsTopic Advisor, Page Editor
Distinguished Expert 2018

Commented:
Can also use : select yourcolumn as [  ] from yourtable

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial