INSERT INTO test_tableSELECT 62UNIONSELECT 91UNIONSELECT 95UNION SELECT 98UNION SELECT 99
CREATE TABLE test( val1 VARCHAR(10), val2 VARCHAR(10), val3 VARCHAR(10), val4 VARCHAR(10))GO INSERT INTO test(val1, val2, val3, val4)(SELECT 'a1', 'a2', 'a3', 'a4')UNION(SELECT 'b1', 'b2', 'b3', 'b4')UNION(SELECT 'c1', 'c2', 'c3', 'c4')GO