Maximize the power of SQL Prompt with SQL Toolbelt Essentials. Watch now.

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

ogrishmanogrishman Posts: 78 Bronze 4
edited February 25, 2015 9:19AM in SQL Prompt
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

Comments

  • Aaron LAaron L Posts: 596 New member
    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.
Sign In or Register to comment.