生成一个12位数的随机数，尝试了带注释的查询有9位数 [英] Generate a random number with 12 digits tried the undernoted query had 9 digits

问题描述

  DECLARE   @ Random   INT ; 
  DECLARE   @ Upper   INT  ; 
  DECLARE   @ Lower   INT  
 
   -     - 这将创建1到999之间的随机数 
  SET   @ Lower  =  1    -     - 最低随机数 
  SET   @ Upper  =  999999999    -     - 最高随机数 
  SELECT   @Random  = ROUND（（（ @ Upper   -   @ Lower  -1）* RAND（）+  @ Lower ）， 0 ） 
  SELECT   @ Random  

我尝试了什么：



在互联网上完成研究并在内部审查了一些代码

解决方案

尝试 -

  SELECT  FLOOR（RAND（ CHECKSUM（NEWID（）））*（999999999999-100000000000）[phone]）

你可以用变量装饰它（如果你觉得有意义的话）

  DECLARE   @ Upper   BIGINT  
  DECLARE   @ Lower   BIGINT  
 
  SET   @ Lower  =  100000000000    -     - 最低随机数 
  SET   @ Upper  = < span class =code-digit> 999999999999    -     - 最高随机数 
 
  SELECT  @ Random = FLOOR（RAND（CHECKSUM（NEWID（）））*（@ Upper- @ Lower）+ @ Lower）
 
  SELECT   @ Random  

或者你可以修改你的查询如下 -

  DECLARE   @ Random   BIGINT ; 
  DECLARE   @ Upper   BIGINT  
  DECLARE   @ Lower   BIGINT  
 
   -     - 这将创建1到999之间的随机数 
  SET   @ Lower  =  100000000000    -     - 最低随机数 
  SET   @ Upper  =  999999999999    -     - 最高随机数 
 
  SELECT   @ Random  = ROUND（（（ @Upper   -   @ Lower  -100000000000）* RAND（）+  @ Lower ），  0 ）
 
  SELECT   @随机 

希望，它有所帮助：）

您尝试过：

  SET   @ Upper  =  999999999999    -     - 最高随机数 

DECLARE @Random INT;
DECLARE @Upper INT;
DECLARE @Lower INT

--- This will create a random number between 1 and 999
SET @Lower = 1 ---- The lowest random number
SET @Upper = 999999999 ---- The highest random number
SELECT @Random = ROUND(((@Upper - @Lower -1) * RAND() + @Lower), 0)
SELECT @Random

What I have tried:

Done research on the internet and reviewed some codes internally

解决方案

Try-

SELECT FLOOR(RAND(CHECKSUM(NEWID()))*(999999999999-100000000000)[phone])

You can decorate it with variable (if you think that's meaningful)

DECLARE @Upper BIGINT
DECLARE @Lower BIGINT

SET @Lower = 100000000000 ---- The lowest random number
SET @Upper = 999999999999 ---- The highest random number

SELECT @Random=FLOOR(RAND(CHECKSUM(NEWID()))*(@Upper-@Lower)+@Lower)

SELECT @Random

Or you can modify your query as following-

DECLARE @Random BIGINT;
DECLARE @Upper BIGINT
DECLARE @Lower BIGINT
 
--- This will create a random number between 1 and 999
SET @Lower = 100000000000 ---- The lowest random number
SET @Upper = 999999999999 ---- The highest random number

SELECT @Random = ROUND(((@Upper - @Lower -100000000000) * RAND() + @Lower), 0)

SELECT @Random

Hope, it helps :)

Did you try:

SET @Upper = 999999999999 ---- The highest random number

这篇关于生成一个12位数的随机数，尝试了带注释的查询有9位数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！