Removing Comments
DavidStein
Posts: 11 Bronze 1
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.
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?
Comments
unchecking show column names and show column data types in
options>inserted code>objects and statements>insert statements.
Product Support
Red Gate Software