字段UID 为自动编号数据类型
select top 1 * from Users order by right(cstr(rnd(-int(rnd(-timer())*100+UID)))*1000*Now(),2)
PS:MSSql 数据库下随机排序
select top 1 * from Users order by newid()
字段UID 为自动编号数据类型
select top 1 * from Users order by right(cstr(rnd(-int(rnd(-timer())*100+UID)))*1000*Now(),2)
PS:MSSql 数据库下随机排序
select top 1 * from Users order by newid()
转载于:https://www.cnblogs.com/hailibu/archive/2010/10/28/1863652.html