BUG: InlineEXEC incorrectly treats $text$ as a substitution

mbray

If a procedure has code that includes $text$ (where 'text' is any word) then the Inline EXEC function incorrectly treats this value as a substitution, removing the $'s and highlighting the text.

Example:

USE tempdb;<br><div>CREATE PROCEDURE TestRG</div><div>AS</div><div>BEGIN</div><div>&nbsp; &nbsp; SELECT 'This is a $BAD$ example'<br></div><div>END<br></div><div>GO</div><div></div>

Then run the 'Inline EXEC' feature on this statement:

EXEC TestRG 

The result will be:

<div>BEGIN</div><div>&nbsp; &nbsp; SELECT 'This is a <b>BAD</b> example'<br></div><div>END</div>