SqlServer 2005及其以上版本能用的查询数据的行号

SELECT ROW_NUMBER() OVER (ORDER BY newid()) AS Id,TopicID, TopicClass, ExamVersion, Topic, TopicAnswer, TopicPic, TopicRemark, Sort
FROM EXAMTOPIC