GENERATE RANDOM NUMBERS AND ALPHANUMERIC RANDOM NUMBERS

DECLARE @I AS NUMERIC

SET @I=1

WHILE @I<100

BEGIN

INSERT INTO PIN_MAST(SL_NO,PIN_ID,PIN_PASS)(

(SELECT 1,ABS(CAST(CAST(NEWID() AS VARBINARY) AS INT)) AS [RandomNumber],CONVERT(varchar(10), right(newid(),10)))

)

SET @I=@I+1

END