在SQL Server中如何用SQL语句建立一张临时表答:create table #t(id int,type varchar(20),name varchar(20),num int)go insert into #t select '1','a','a1','0' union all select '2','a','a2','1' union all select '3','a','a3','2' union all select '4','b','b1','0' union all select '5','b','b2','...