SQL 9位随机码

select convert(int, CONVERT(nvarchar, ceiling(RAND(CHECKSUM(NEWID()))*9))+RIGHT(100000000 + CONVERT(bigint, ABS(CHECKSUM(NEWID()))), 8))
posted @ 2011-08-16 16:16  Rex.He  阅读(346)  评论(0)  编辑  收藏  举报