SQL Server 2008中SQL增强之一:Values新用途 001时间:2023-03-09 20:10:47 连接集合 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)