sql 随机数

Question

我要作随机数的问题 
要求 四位一组 前两个四位 确定 后两个四位是随机数请各位帮忙 谢谢

Answer 1

select '1234 4321 '+right('0000'+ltrim(rand()),4)
                   
------------------ 
1234 4321 3647（所影响的行数为 1 行）

Answer 2

SELECT '4564'+'7897'+LEFT(ABS(CHECKSUM(NEWID())),4)?

Answer 3

select '1111 2222'+' '+right(rand(),4)------------------
1111 2222 9266(1 行受影响)

Answer 4

问题不是很清晰，但是
select right(rand(),4)
基本能解决你的问题

Answer 5

select 'AAAA'+'-'+'BBBB'+'-'+Right(LTRIM(Rand()),4) 

Answer 6

select '1234'+' '+'5678'+' '+Right(LTRIM(Rand()),4)+' '+Right(LTRIM(Rand()),4)  

Answer 7

select '1010 '+'5756 '+left(abs(CHECKSUM(RAND())),4)+' '+left(abs(CHECKSUM(RAND())),4)

Answer 8

select '1010 5756 '||dbms_random.string('x',4)||' '||dbms_random.string('x',4) from dual

Answer 9

直接  SELECT '1010 '+'5756 ' + RIGHT(RAND(),4)+' '+RIGHT(RAND(),4)

Answer 10

 select '1010 5756 '+right('0000'+convert(varchar(4),convert(int,rand()*10000)),4)+' '+right('0000'+convert(varchar(4),convert(int,rand()*10000)),4);

Answer 11

谢谢 大家啊 呵呵 Thanks