Do snippets support multiple variable expansion?

When I read snippets, I assumed SSMS or VS style snippets, except with less PITA experience. Unless I am missing something, the snippets in SQLPrompt5 are a more limited replacement. Please tell me it ain't so.

I want to quickly be able to group by a given column in a given table and sort by the count DESC.

SELECT DomainLogin, COUNT(*)
FROM Proposal
GROUP BY DomainLogin
ORDER BY COUNT(*) DESC

So in this case there would be 2 varibles: column name (DomainLogin in this case) and table name (Proposal in this case).

It seems like SQL Prompt 5 supports $CURSOR$ for variables, but only a single one. And it definitely doesn't seem to support tabbing between variables, a la Visual Studio.

Am I wrong?

rgelb October 08, 2012 18:50

Comments

4 comments

Here is some documentation on using SSMS templates in SQL Prompt snippets.
http://www.red-gate.com/supportcenter/content/SQL_Prompt/help/5.3/sp_ssms_templates

Manfred.Castro October 09, 2012 19:37

0
Doesn't have the elegance of visual studio (or even SSMS) snippets, but I guess, it gets the job done.

rgelb October 09, 2012 19:42

0
You can use the SSMS template parameters in conjunction with SQL Prompt snippets. Would this help?

see http://www.simple-talk.com/blogs/2012/0 ... arameters/

David

David Atkinson October 09, 2012 19:59

0
*bump*

Multiple $CURSOR$ positions with tab-between would be awesome.

Microsoft templates are lame because there is no autocomplete.

Thanks.

eggnog January 24, 2013 22:03

0

Add comment

Please sign in to leave a comment.

How can we help you today?

Do snippets support multiple variable expansion?

Comments

Add comment