How can we help you today? How can we help you today?

Modify Insert Into template?

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
0

Comments

1 comment

Sort by
  • 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.
    Manfred.Castro
    0

Add comment

Please sign in to leave a comment.