How can we help you today? How can we help you today?

SQL Prompt doesn't support the pseudo column %%physloc%%

When the query include the pseudo column %%physloc%%, SQL Prompt marks it as an syntax error. But SQL Server will correctly execute the query and gives me the result. Please take a look at the following snapshot.

zayG0YS.png
ogrishman
0

Comments

1 comment

Sort by
  • Aaron L
    Hi Ogrishman,

    Thanks for letting us know!

    It looks like this feature isn't documented or supported by Microsoft and it's technically not valid SQL either (as %% isn't the start of a valid identifier). I have logged a feature enhancement request under SP-5342 but I can't confirm for sure when we'll work on it. I guess it does have some similarities to the SQLCMD mode support we just put in so it could potentially be included with that.

    Thanks,
    Aaron.
    Aaron L
    0

Add comment

Please sign in to leave a comment.