You can insert multiple rows together in table in SQL Server using below 3 methods:
CREATE TABLE Test (ID INT, Value VARCHAR(100));
1. INSERT INTO Test (ID, Value) VALUES (1, 'One');
INSERT INTO Test (ID, Value) VALUES (2, 'Two');
INSERT INTO Test (ID, Value) VALUES (3, 'Three');
2. INSERT INTO Test (ID, Value)
SELECT 1, 'One'
UNION ALL
SELECT 2, 'Two'
UNION ALL
SELECT 3, 'Three';
3. INSERT INTO Test (ID, Value)
VALUES (1, 'One'), (2, 'Two'), (3, 'Three');
CREATE TABLE Test (ID INT, Value VARCHAR(100));
1. INSERT INTO Test (ID, Value) VALUES (1, 'One');
INSERT INTO Test (ID, Value) VALUES (2, 'Two');
INSERT INTO Test (ID, Value) VALUES (3, 'Three');
2. INSERT INTO Test (ID, Value)
SELECT 1, 'One'
UNION ALL
SELECT 2, 'Two'
UNION ALL
SELECT 3, 'Three';
3. INSERT INTO Test (ID, Value)
VALUES (1, 'One'), (2, 'Two'), (3, 'Three');
Very useful for bulk insert. thanks.
ReplyDeleteYou save my a lots of time..Thanks.. :)
ReplyDelete