Generate random numbers in SQL (any digit number)

declare @val as bigint

Set @val =(Select ABS(CAST(CAST(NEWID() AS VARBINARY(6)) AS Bigint)))

Select substring(cast(@val as varchar(15)),1,14) as Rand_id

14 – to control the number length