插入多行数据和类似 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  
*/