SQL SERVER – Insert Multiple Records Using One Insert Statement – Use of UNION ALL | Journey to SQL

SQL SERVER – Insert Multiple Records Using One Insert Statement – Use of UNION ALL | Journey to SQL

瀏覽:841
日期:2025-05-03
INSERT using UNION is not a way to improve the performance. I had tried inserting 35706 records to a table (int values). The normal insert way (35706 insert statements) took just 9 seconds to complete the execution whereas the union all way takes more tha...看更多