Answer: insert combine (value and select)

answer re: insert combine (value and select)

Feb 14 '11

39

Just add a constant into the SELECT list

INSERT INTO MyTable
            (ColA,
             ColB,
             ColC)
SELECT 1,
       colBB,
       colCC
FROM   MyTable2  

Open Full Answer