Category Archives: SELECT

Easy SQL Insert for Multiple Rows

Here’s a quick and easy way of inserting data. INSERT INTO Beatles (FirstName, Surname) SELECT ‘John’, ‘Lennon’ UNION ALL SELECT ‘Paul’, ‘McCartney’ UNION ALL SELECT ‘George’, ‘Harrison’ UNION ALL SELECT ‘Ringo’, ‘Starr’ GO We start with INSERT INTO and the … Continue reading

Posted in INSERT, SELECT, SQL, UNION | Tagged , , , | Comments Off on Easy SQL Insert for Multiple Rows