Modify Insert Into template?

StormRider

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 */ )

Manfred.Castro

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.