mssql how to insert more than 1000 rows

Dami answered on February 23, 2022 Popularity 7/10 Helpfulness 5/10

answer mssql how to insert more than 1000 rows

mssql how to insert more than 1000 rows

Comment

BEGIN TRANSACTION; -- Whenever possible use transactions when dealing with large amounts of data
INSERT INTO [database].[dbo].[table_name] ([field1], [field2], [field3])
SELECT 'value for row 1 field 1', 'value for row 1 field 2', 'value for row 1 field 3' UNION ALL
SELECT 'value for row 2 field 1', 'value for row 2 field 2', 'value for row 2 field 3' UNION ALL
-- ...N-thousand other rows...
SELECT 'value for row n-1 field 1', 'value for row n-1 field 2', 'value for row n-1 field 3' UNION ALL
SELECT 'value for row n field 1', 'value for row n field 2', 'value for row n field 3'; -- No 'UNION ALL' statement on the last line
COMMIT TRANSACTION;

Popularity 7/10 Helpfulness 5/10 Language sql

Source: Grepper

Tags: insert rows sql

Link to this answer
Share Copy Link

Contributed on Feb 23 2022

Dami

0 Answers Avg Quality 2/10

mssql how to insert more than 1000 rows

Contents

More Related Answers

mssql how to insert more than 1000 rows

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.