Multiple rows insert

Multiple rows insert

• You don’t have to re-create the entire INSERT statement over and over
• Sample：

USE [tempdb] GO IF (object_id(N'tempdb..#T1') IS NOT NULL)      DROP TABLE #T1;      CREATE TABLE [dbo].[#T1]([C1] [int] NOT NULL, [C2] [nvarchar](50) NOT NULL, CONSTRAINT [PK_T1] PRIMARY KEY CLUSTERED ([C1] ASC)WITH (PAD_INDEX=OFF,STATISTICS_NORECOMPUTE=OFF, IGNORE_DUP_KEY=OFF, ALLOW_ROW_LOCKS=ONALLOW_PAGE_LOCKS=ON) ON[PRIMARY] )ON [PRIMARY] GO INSERT INTO #T1 VALUES (1, 'A'), (2, 'B'), (3, 'C'); GO --TRUNCATE TABLE [tempdb].[dbo].[#T1] --DROP TABLE #T1 SELECT * FROM [tempdb].[dbo].[#T1]