Removing Comments

Provides intelligent code completion for SQL Server editors.

Moderators: JonathanWatts, David Atkinson, Anu Deshpande, Paul Stephenson, Michelle Taylor, Mike Upton, justin.caldicott, Aaron Law

Removing Comments

Postby DavidStein » Mon Oct 15, 2012 11:12 pm

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: Select all
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?
DavidStein
 
Posts: 4
Joined: Mon Oct 01, 2012 4:32 pm

Postby Manfred.Castro » Wed Oct 17, 2012 12:24 am

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
Manfred.Castro
 
Posts: 209
Joined: Mon Apr 23, 2012 2:49 pm


Return to SQL Prompt 5

Who is online

Users browsing this forum: No registered users and 0 guests