SELECT ROW_NUMBER() OVER (ORDER BY newid()) AS Id,TopicID, TopicClass, ExamVersion, Topic, TopicAnswer, TopicPic, TopicRemark, Sort
FROM EXAMTOPIC
SELECT ROW_NUMBER() OVER (ORDER BY newid()) AS Id,TopicID, TopicClass, ExamVersion, Topic, TopicAnswer, TopicPic, TopicRemark, Sort
FROM EXAMTOPIC
转载于:https://www.cnblogs.com/Kiss920Zz/archive/2012/05/16/2503930.html