Red Gate forums :: View topic - Removing Comments
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

Removing Comments

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



Joined: 01 Oct 2012
Posts: 4

PostPosted: Mon Oct 15, 2012 11:12 pm    Post subject: Removing Comments Reply with quote

I really like how your product assists with insert statements. However, I am then left with a large list of comments which I'm not allowed to check into source control. Therefore, I have to manually delete each line of comments. Take a look at the following statement that was generated by SQLPrompt.

Code:
INSERT  INTO dbo.sorels (fenumber, finumber, fpartno, fpartrev, frelease, fshptoaddr, fsono, favailship, fbook, fbqty,
                         fdiscount, fduedate, finvamount, finvqty, fjob, fjoqty, flabcost, flngth, flshipdate,
                         fmasterrel, fmatlcost, fmaxqty, fmqty, fmsi, fnetprice, fninvship, fnpurvar, forderqty,
                         fothrcost, fovhdcost, fpoqty, fpostatus, fquant, fsetupcost, fshipbook, fshipbuy, fshipmake,
                         fshpbefdue, fsplitshp, fstatus, fstkqty, fsubcost, ftoolcost, ftoshpbook, ftoshpbuy, ftoshpmake,
                         funetprice, fvendno, fwidth, fnretpoqty, fnettxnprice, funettxnpric, fneteuropr, funeteuropr,
                         fdiscpct, fljrdif, flistaxabl, flatp, fcbin, fcloc, timestamp_column, fdelivery, fcpbtype,
                         fcudrev, fndbrmod, fpriority, SchedDate, flInvcPoss)
VALUES  ('', -- fenumber - char(3)
         '', -- finumber - char(3)
         '', -- fpartno - char(25)
         '', -- fpartrev - char(3)
         '', -- frelease - char(3)
         '', -- fshptoaddr - char(4)
         '', -- fsono - char(6)
         NULL, -- favailship - bit
         NULL, -- fbook - numeric
         NULL, -- fbqty - numeric
         NULL, -- fdiscount - numeric
         '2012-10-15 22:09:55', -- fduedate - datetime
         NULL, -- finvamount - numeric
         NULL, -- finvqty - numeric
         NULL, -- fjob - bit
         NULL, -- fjoqty - numeric
         NULL, -- flabcost - numeric
         NULL, -- flngth - numeric
         '2012-10-15 22:09:55', -- flshipdate - datetime
         NULL, -- fmasterrel - bit
         NULL, -- fmatlcost - numeric
         NULL, -- fmaxqty - numeric
         NULL, -- fmqty - numeric
         NULL, -- fmsi - numeric
         NULL, -- fnetprice - numeric
         NULL, -- fninvship - numeric
         NULL, -- fnpurvar - money
         NULL, -- forderqty - numeric
         NULL, -- fothrcost - numeric
         NULL, -- fovhdcost - numeric
         NULL, -- fpoqty - numeric
         '', -- fpostatus - char(6)
         NULL, -- fquant - numeric
         NULL, -- fsetupcost - numeric
         NULL, -- fshipbook - numeric
         NULL, -- fshipbuy - numeric
         NULL, -- fshipmake - numeric
         NULL, -- fshpbefdue - bit
         NULL, -- fsplitshp - bit
         '', -- fstatus - char(10)
         NULL, -- fstkqty - numeric
         NULL, -- fsubcost - numeric
         NULL, -- ftoolcost - numeric
         NULL, -- ftoshpbook - numeric
         NULL, -- ftoshpbuy - numeric
         NULL, -- ftoshpmake - numeric
         NULL, -- funetprice - numeric
         '', -- fvendno - char(6)
         NULL, -- fwidth - numeric
         NULL, -- fnretpoqty - numeric
         NULL, -- fnettxnprice - numeric
         NULL, -- funettxnpric - numeric
         NULL, -- fneteuropr - numeric
         NULL, -- funeteuropr - numeric
         NULL, -- fdiscpct - numeric
         NULL, -- fljrdif - bit
         NULL, -- flistaxabl - bit
         NULL, -- flatp - bit
         '', -- fcbin - char(14)
         '', -- fcloc - char(14)
         NULL, -- timestamp_column - timestamp
         '', -- fdelivery - text
         '', -- fcpbtype - char(1)
         '', -- fcudrev - char(3)
         NULL, -- fndbrmod - numeric
         0, -- fpriority - int
         '2012-10-15 22:09:55', -- SchedDate - datetime
         NULL  -- flInvcPoss - bit
         )


Does SQLPrompt have a mechanism by which it can then remove all of those comments?
Back to top
View user's profile Send private message
Manfred.Castro



Joined: 23 Apr 2012
Posts: 209

PostPosted: Wed Oct 17, 2012 12:24 am    Post subject: Reply with quote

You can remove those comments by
unchecking show column names and show column data types in
options>inserted code>objects and statements>insert statements.
_________________
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