Inserting multiple rows of data is similar to the select Union method.

Cite: http://blog.csdn.net/downmoon/article/details/5936706

[ruby] view plaincopyprint? Create table Demo_Values  (PKID int not null identity(1,1) primary key  ,DName Nvarchar(20) null  ,DCode NVarchar(30) null  ,DDate datetime null  )  go  --this SQL is only for SQL Server 2008  Insert into Demo_Values  (DName,DCode,DDate)  values  (‘DemoA‘,‘AAA‘,GETDATE()),  (‘DemoB‘,‘BBB‘,GETDATE()),  (‘DemoC‘,‘CCC‘,GETDATE()),  (‘DemoD‘,‘DDD‘,GETDATE()),  (‘DemoE‘,‘EEE‘,GETDATE())  --(5 row(s) affected)  

Construct a temporary result set. Construct a result set like union.

[ruby] view plaincopyprint?--this SQL is only for SQL Server 2008  select DName,DCode,DDate  from  (values  (‘DemoA‘,‘AAA‘,GETDATE()),  (‘DemoB‘,‘BBB‘,GETDATE()),  (‘DemoC‘,‘CCC‘,GETDATE()),  (‘DemoD‘,‘DDD‘,GETDATE()),  (‘DemoE‘,‘EEE‘,GETDATE())  )  Demo_Values (DName,DCode,DDate)  --(5 row(s) affected)  /*  DName    DCode    DDate  DemoA    AAA    2010-10-12 20:37:45.500  DemoB    BBB    2010-10-12 20:37:45.500  DemoC    CCC    2010-10-12 20:37:45.500  DemoD    DDD    2010-10-12 20:37:45.500  DemoE    EEE    2010-10-12 20:37:45.500  */  

 

Inserting multiple rows of data is similar to the select Union method.