Snippet and special charaters

Provides intelligent code completion for SQL Server editors.

Moderators: David Atkinson, Anu Deshpande, Luke Jefferson

Snippet and special charaters

Postby rcraill » Thu Nov 04, 2010 8:09 am

when i try enter a snippet it leaves out and shift charaters ie *(). Is there a special way to capture these.
eg select * from Bidtable where substring(company,1,7)= 'chas ev' order by company
if you test you get
select * from Bidtable where substringcompany,1,7= 'chas ev' order by company

Missing ()
rcraill
 
Posts: 1
Joined: Thu Nov 04, 2010 8:06 am

Postby james.billings » Fri Nov 05, 2010 12:04 pm

Thanks for your post. I tried creating a snippet based on what you posted, but the brackets work ok for me and appear.

Can I check - what version of SSMS are you using? And if you haven't already, can you try the latest patch? (look for the "Latest cumulative patch" post in the forum)
james.billings
 
Posts: 1144
Joined: Wed Jun 16, 2010 11:10 am
Location: My desk.


Return to SQL Prompt Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests