select convert(int, CONVERT(nvarchar, ceiling(RAND(CHECKSUM(NEWID()))*9))+RIGHT(100000000 + CONVERT(bigint, ABS(CHECKSUM(NEWID()))), 8))
转载于:https://www.cnblogs.com/hejunrex/archive/2011/08/16/2140748.html
转载于:https://www.cnblogs.com/hejunrex/archive/2011/08/16/2140748.html