-- var to hold random value<\/div>
declare @field_val int<\/div>
<\/div>
-- create table var to hold value range [ 0, 512, 1024, 1536, 2048 ]<\/div>
SELECT 0 AS \'num\'<\/div>
INTO #temp<\/div>
<\/div>
-- insert data into table var<\/div>
INSERT INTO #temp VALUES ( 512 )<\/div>
INSERT INTO #temp VALUES ( 1024 )<\/div>
INSERT INTO #temp VALUES ( 1536 )<\/div>
INSERT INTO #temp VALUES ( 2048 )<\/div>
<\/div>
-- assign random value<\/div>
SELECT TOP 1 @field_val = num FROM #temp ORDER BY NEWID()<\/div>
<\/div>
-- show value<\/div>
SELECT @field_val<\/div>
<\/div>
-- drop it<\/div>
DROP TABLE #temp<\/div><\/pre><\/div>\n \n <\/div>\n\n