-- 2005 이상에서만 될걸요?? 아마도요 ㅋ
Select
number,
ABS(CAST(CAST(NEWID() AS VARBINARY) AS int)) % 10000 / 1000 % 5 + 1 as column3
From master..spt_values
Where Type = 'P'
-- 2005 이상에서만 될걸요?? 아마도요 ㅋ
Select
number,
ABS(CAST(CAST(NEWID() AS VARBINARY) AS int)) % 10000 / 1000 % 5 + 1 as column3
From master..spt_values
Where Type = 'P'