亂數產生5個數字字元進行UPDATE

此法不好
SELECT RIGHT(CONVERT(varchar ,Rand()),5) as RandomNumber

此法比較好
RIGHT(CONVERT(varchar,abs(cast(cast(newid() as binary(4)) as int)) + 30000000000),5)



原文出自於此