What are the challenges you face when working across database platforms? Take the survey
Options

Modify Insert Into template?

StormRiderStormRider Posts: 26
edited September 21, 2012 2:49PM in SQL Prompt Previous Versions
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 */ )

Comments

Sign In or Register to comment.