Tag Archive: row constructor

Microsoft SQL SELECT INTO multiple values

Today I came across an interesting construct in Microsoft SQL whereby you are allowed to insert multiple values into a table using a single SELECT INTO statement. Naturally there are more ways of achieving the same goal (SELECT..UNION, CREATE TABLE .. INSERT INTO) but I thought it would be interesting to post this option here …

Continue reading »