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

Removing Comments

DavidSteinDavidStein Posts: 11 Bronze 1
edited October 16, 2012 7:24PM in SQL Prompt Previous Versions
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.
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?

Comments

  • Options
    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
Sign In or Register to comment.