Escape Template Parameter -
02-12-2009
, 06:03 PM
SQL Server Management Studio documentation instructions:
To replace template parameters
On the Query menu
click Specify Values for Template Parameters
When I follow those instructions replacment dialog contains several false
positives.
The following two lines demonstrate examples of false positives:
If ascii(substring(@var, @var2, 1)) < 48 OR ascii(substring(@var3, @var4,
1)) > 57
Set @xmlEvent = @xmlEvent + '<elem1>' + Rtrim(Convert(varchar(30), @var1,
126)) + '</elem>'
The statements abover are complex statements that result in template match,
when it is clearly not a template. I'd like to use template feature for a
file like that, but this type of false matching prevents me from using
templates. |