首页 > 代码库 > 插入多行数据和类似 select union 方法

插入多行数据和类似 select union 方法

    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)  

  构造一个临时结果集。像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  */  

  

 

插入多行数据和类似 select union 方法