Insert Multiple Rows Into Temp Table
xxxxxxxxxx
CREATE TABLE Names
(
Name1 VARCHAR(100),
Name2 VARCHAR(100)
)
INSERT INTO Names
(Name1, Name2)
VALUES
('Matt', 'Matthew'),
('Matt', 'Marshal'),
('Matt', 'Mattison');
SELECT * FROM NAMES
Name1 | Name2 |
---|---|
Matt | Matthew |
Matt | Marshal |
Matt | Mattison |
(3 rows affected)