declare @re int,@num int select @num =8 select @re=CONVERT(int, POWER(10,@num)*RAND()) if len(@RE) select POW…