0

I have a SP which returns some columns, each column name has space between them like

branch Code Branch Name (We are assigning alias in our SP)

Now while using fmtonly off I get the column name as returned by the SP, but when I set fmtonly to on it remove the spaces between Column name.

Is it possible to get the same column name returned by SP while setting fmtonly to on?

Thanks

Bridge
  • 29,818
  • 9
  • 60
  • 82
Muhammad Taqi
  • 305
  • 2
  • 6
  • 19
  • Which RDBMS is this for? Please add a tag to specify whether you're using `mysql`, `postgresql`, `sql-server`, `oracle` or `db2` - or something else entirely. – marc_s Jan 13 '16 at 07:42
  • Im using Sql Server 2008 R2 – Muhammad Taqi Jan 13 '16 at 08:00
  • 1
    [Edit](https://meta.stackexchange.com/questions/21788/how-does-editing-work) your stored procedure into your question. Also, why do you want to use `SET FMTONLY ON`... what are your specific requirements to do that? – TT. Jan 13 '16 at 08:23
  • My SP is way to long but just to give you a hint select schema_id as 'schema id' from sys.tables Also I cannot change the SP – Muhammad Taqi Jan 13 '16 at 08:29
  • 1
    Well, we don't need your exact SP, but please try to create a [mcve] and [edit] that into your question (because code in comments is unreadable, whereas in the question, you can highlight code blocks and hit `{}` and we get readable code with syntax highlighting) – Damien_The_Unbeliever Jan 13 '16 at 09:10

0 Answers0