7-Bedrock

Solved

ThingWorx SQL Query

Hi all,

I have to run a query on MS SQL Database table, which has columns with spaces in their names (ex: 'SA03 LH CS BRG DEPTH (mm)').

How do I query this successfully?

Here is an example query:

SELECT *

FROM <<tableName>>

WHERE <<tagName>> != 0;

Here <<tagName>> is a column with space in its name.

Best answer by Arun_C

Hi @PSB ,

I have tried in MS SQL DB. Kindly find the below atttached snapshot for your references.

Thanks & Regards,

Arun C

16-Pearl

Hi @PSB ,

I have tried with PostgreSQL Query. It is working for me.

SELECT * FROM public.accounts where "SA03 LH CS BRG DEPTH (mm)" = 1

Thanks & Regards,

Arun C

Author

7-Bedrock

Hi @Arun_C ,

PFA screenshot, I have tried it on MS SQL it doesn't seem to be working.

Screenshot 2024-05-21 100135.png Screenshot 2024-05-21 102027.png

Can you try it on MS SQL & let me know.

Answer

16-Pearl

Hi @PSB ,

I have tried in MS SQL DB. Kindly find the below atttached snapshot for your references.

Thanks & Regards,

Arun C

Sign up