Skip to main content
Question

Work around for SQLExecutor when a column name contains a reserved word

  • December 12, 2024
  • 1 reply
  • 19 views

cochdp
Contributor
Forum|alt.badge.img+1

A column name that I am trying to SELECT in the SQLExecutor is titled: STATE

The line in the SQLExecutor that contains it is as follows:

I receive an error message that leads me to believe that it is not grabbing this column, and instead trying to grab the alias that I am trying to establish:

Is there a reliable work around for this reserved word?

 

I have tried using the following, to no avail:

[STATE]

[“STATE”]

[state]

“[STATE]”

1 reply

ctredinnick
Supporter
Forum|alt.badge.img+18
  • Supporter
  • December 13, 2024

Is State a reserved word?

https://learn.microsoft.com/en-us/sql/t-sql/language-elements/reserved-keywords-transact-sql

Try without the [ ]. Else, seems like the issue is somewhere else in your script, like a subquery.


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings