[MSSQL] 랜덤 난수 생성
--============================== --기본적으로 6자리로 설정(999999) --============================== Declare @maxRandomValue int, @minRandomValue int;Select @maxRandomValue = 999999, @minRandomValue = 0; Select randomNumber = Cast(((@maxRandomValue + 1) - @minRandomValue) * Rand() + @minRandomValue As int);
2014. 5. 14. 14:46