第一列自动生成 自增

SELECT     ROW_NUMBER() OVER (ORDER BY a.ID ASC) AS ID, a.CoachId, a.CoachNo, a.CoachName, isnull(b.Price, 0) CoachPrice
FROM         Coach a LEFT JOIN
                      dbo.CoachPrice b ON a.CoachId = b.CoachId
WHERE     a.IsDelete = 0