sqlserver 2008 with 关键字怎么用

Answer 1

;with test as (select * from 表)
select * from test