【专家解说】:create table #test(code varchar(36),num int)
--all用法
insert into #test
select newid(),1
union all
select newid(),20
union all
select newid(),28
union all
select newid(),15
select * from #test
--alter add用法
alter table #test
add name varchar(30)
----any用法,类似 in关键字
select * from #test
where num > any(select num from #test)
--as asc用法
select code,num,name as colname
from #test
order by num asc
drop table #test