试试看，

Hi try this,

Select * from tablename order by newid()

这将随机检索行...

this will retrieve the rows randomnly...

要选择随机记录，请结合TOP和NEWID:

To select a random record, combine TOP with NEWID:

SELECT TOP 1 * from MyTable ORDER BY NEWID()

您可能需要用过程输出替换MyTable.

In your case, you will probably need to replace MyTable with your procedure output.