SQL查询结果加自增列

select  IDENTITY(INT,1,1) as id ，* from **   ----select into 时可用