Assign a unique count to each row in the resulting table of a select statement
You can use ROW_NUMBER, like this:

SELECT 
    ROW_NUMBER()OVER(ORDER BY ID ASC) AS [Count],
    body 
FROM @Article AS A
WHERE authorid=1


Count                body
1                    Hi
2                    there
3                    foo