Red Gate forums :: View topic - Do snippets support multiple variable expansion?
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Prompt 5
SQL Prompt 5 forum

Do snippets support multiple variable expansion?

Search in SQL Prompt 5 forum
Post new topic   Reply to topic
Jump to:  
Author Message
rgelb



Joined: 25 Sep 2008
Posts: 26

PostPosted: Mon Oct 08, 2012 11:50 pm    Post subject: Do snippets support multiple variable expansion? Reply with quote

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?
Back to top
View user's profile Send private message
Manfred.Castro



Joined: 23 Apr 2012
Posts: 205

PostPosted: Wed Oct 10, 2012 12:37 am    Post subject: Reply with quote

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
Product Support
Red Gate Software
Back to top
View user's profile Send private message
rgelb



Joined: 25 Sep 2008
Posts: 26

PostPosted: Wed Oct 10, 2012 12:42 am    Post subject: Reply with quote

Doesn't have the elegance of visual studio (or even SSMS) snippets, but I guess, it gets the job done.
Back to top
View user's profile Send private message
David Atkinson



Joined: 05 Dec 2005
Posts: 1112

PostPosted: Wed Oct 10, 2012 12:59 am    Post subject: Reply with quote

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

see http://www.simple-talk.com/blogs/2012/04/20/using-a-sql-prompt-snippet-with-template-parameters/

David
Back to top
View user's profile Send private message Send e-mail
eggnog



Joined: 25 Jan 2013
Posts: 1

PostPosted: Fri Jan 25, 2013 4:03 am    Post subject: Reply with quote

*bump*

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

Microsoft templates are lame because there is no autocomplete.


Thanks.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group