when I am trying to get the results from the DB (SQL Server), there are some column names as "Show Room Code".
The query i am using to get the results is:
| dbquery "Centro" "SELECT TransTime,Quantity,Amount,Show Room Code FROM Centro_Daily_Dummy" limit=1000
Then it is showing it as error : command="dbquery", A database error occurred: Incorrect syntax near 'Code'.
if the query is edited without Show Room Code then it is running correctly.
There are white spaces in the column name in the DB. how to get such columns in Splunk.