Modify Insert Into template?

Provides intelligent code completion for SQL Server editors.

Moderators: JonathanWatts, David Atkinson, Anu Deshpande, Paul Stephenson, Michelle Taylor, Mike Upton, justin.caldicott, Aaron Law

Modify Insert Into template?

Postby StormRider » Thu Sep 20, 2012 6:09 pm

Is it possible to modify the Insert Into template?

currently when you use the Insert Into generator, you get this:

INSERT INTO dbo.Sitemap
( SitemapId ,
ParentId ,
ApplicationId
)
VALUES ( 0 , -- SitemapId - int
0 , -- ParentId - int
0 -- ApplicationId - int
)

Which is great for one or 2 records, but quite often I need to do 5+, and I end up reformatting like this:

INSERT INTO dbo.Sitemap ( SitemapId, ParentId, ApplicationId) VALUES ( 0 , 0 , 0 )

I'd like to alter the template to generate this:

INSERT INTO dbo.Sitemap ( SitemapId, ParentId, ApplicationId ) VALUES ( 0 /* SitemapId */, 0 /* ParentId */, 0 /* ApplicationId */ )
StormRider
 
Posts: 14
Joined: Thu Nov 10, 2011 2:20 am

Postby Manfred.Castro » Fri Sep 21, 2012 7:49 pm

Unfortunately it is not possible to modify the template.

If you wish you can request this feature in our uservoice forums.
http://redgate.uservoice.com/forums/94413-sql-prompt-feature-suggestions
These forums allow our users to request features for our products.
DEvelpoment actively monitor these forums and when a request recieves significant support the feature maybe implemented in a future release.
Manfred Castro
Product Support
Red Gate Software
Manfred.Castro
 
Posts: 209
Joined: Mon Apr 23, 2012 2:49 pm


Return to SQL Prompt 5

Who is online

Users browsing this forum: No registered users and 0 guests