Just add a constant into the SELECT list
INSERT INTO MyTable
(ColA,
ColB,
ColC)
SELECT 1,
colBB,
colCC
FROM MyTable2
Max Angelo Dapitilla Perin
Posted on
Answer: insert combine (value and select)
For further actions, you may consider blocking this person and/or reporting abuse
Top comments (0)