sql随机读取记录语句RAND()与newid()

sql 随机读取记录语句rand()与newid()
有人随机函数 rand（）
如

select * from a order by rand();

mssql newid()

select * from a order by newid;