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