난수 만드는 쿼리

SET NOCOUNT ON

CREATE TABLE Coupon(
CouponCode1 CHAR(19) NOT NULL,
CouponCode2 CHAR(19) NOT NULL,
CouponCode3 CHAR(19) NOT NULL,
CouponCode4 CHAR(19) NOT NULL,
CouponCode5 CHAR(19) NOT NULL
)
GO

DECLARE @CNT INT

SET @CNT = 1

WHILE(@CNT <= 100000)
BEGIN
INSERT Coupon VALUES( char((abs(checksum(newid()))%26)+65)+char((abs(checksum(newid
()))%26)+65)+char((abs(checksum(newid()))%26)+65)+char((abs(checksum(newid()))%26)+65)
, convert( int, (rand() * 9)+1 ), convert( int, (rand() * 9)+1 ), convert( int, (rand() * 9)+1 ), convert( int, (rand() * 9)+1 ))

SET @CNT = @CNT + 1
END
GO
SET NOCOUNT OFF

SELECT CouponCode1, COUNT(*) FROM Coupon
GROUP BY CouponCode1
ORDER BY COUNT(*) DESC