dbTalk Databases Forums  

Escape Template Parameter

microsoft.public.sqlserver.tools microsoft.public.sqlserver.tools


Discuss Escape Template Parameter in the microsoft.public.sqlserver.tools forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Izorich
 
Posts: n/a

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

Reply With Quote
  #2  
Old   
Robbie Meng
 
Posts: n/a

Default RE: Escape Template Parameter - 02-13-2009 , 04:55 AM






Hi Sir

Base on the post description, this post <43273980
/microsoft.public.sqlserver.tools > mentioned the same problem of another
post <43273981/ microsoft.public.sqlserver.tools >. Therefore, this post
will be archived so that the incident will not be counted. I will work on
post <<43273981/ microsoft.public.sqlserver.tools > with you as soon as
possible. If you have any concerns, please feel free to drop me a note.

Thank you for your understanding and cooperation!

Best Regards,
Robbie Meng
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscripti...ult.aspx#notif
ications
<http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx>.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
<http://msdn.microsoft.com/subscriptions/support/default.aspx>.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.