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.



  • 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.

Sign In or Register to comment.