2 results found
Please add TRY_CAST to you list of key words in SQL Prompt.
Henrik Staun Poulsen
Vestas Data Center
Vestas Technology R&D1 vote
Unfortunately the script syntax highlighting is not handled by SQL Prompt. It’s something that’s built into SSMS and so we don’t have control over which keywords get marked as pink.
When writing statements like 'ssf s [tab] [enter]' to produce the statement in exhibit A based on the prompt suggestions, the alias 's' gets interpreted as another shortcut for additional keywords as seen in exhibit B. It would be nice if SQL Prompt was aware of its own shortcuts and produced some other unique alias so it didn't collide and create parser errors
SELECT * FROM config.Service AS S
SELECT * FROM config.Service AS SELECT16 votes
I’m going to close this request because it looks like this was only an issue when the SSMS Tools Pack was installed – the solution was to disable snippets in the tools pack. If you’re still having problems with its snippets disabled then let me know.
- Don't see your idea?