with列名

with a(a,b,c)as(
SELECT [deptid],[deptname],[deptmgrid] FROM [T].[dbo].[Departments]
)
select * from a