[MSSQL] 랜덤 난수 생성

--==============================
--기본적으로 6자리로 설정(999999)
--==============================

Declare @maxRandomValue int, @minRandomValue int;

Select @maxRandomValue = 999999, @minRandomValue = 0;

 

Select randomNumber = Cast(((@maxRandomValue + 1) - @minRandomValue) * Rand() + @minRandomValue As int);