随机数

select ((CONVERT([nvarchar],char((65)+ceiling(rand()*(25))),0)+CONVERT([nvarchar],char((65)+ceiling(rand()*(25))),0))+CONVERT([nvarchar],ceiling(rand()*(1000000)),0))

原文地址:https://www.cnblogs.com/guozhe/p/4268251.html