I don't think it can be done using a SET command. Showing or hiding column headers is something that happens on the client side, not at the server side.
You can use the sqlcmd utility to query the database and suppress headers:
For more information see sqlcmd Utility.
Hope this helps