SQL Server 2008中SQL增强之一：Values新用途 001

连接集合

select '1' as id,'wang' as name
union 
select '2' as id,'admin' as name

 
现在可以这么写了

select id,name
from
(values
('1','wang'),
('2','admin')
)
users(id,name)