Snippet and special charaters
rcraill
Posts: 2
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 ()
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 ()
Comments
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)
Redgate Software