Red Gate forums :: View topic - Modify Insert Into template?
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

Modify Insert Into template?

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



Joined: 10 Nov 2011
Posts: 14

PostPosted: Thu Sep 20, 2012 6:09 pm    Post subject: Modify Insert Into template? Reply with quote

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



Joined: 23 Apr 2012
Posts: 209

PostPosted: Fri Sep 21, 2012 7:49 pm    Post subject: Reply with quote

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
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