SQL随机数

 

随机正负50

select (select cast(ceiling(rand(checksum(newid()))*50) as  int)+cast(ceiling(rand(checksum(newid()))*50) as  int)*-1) as Direction

posted on 2017-11-15 19:45  取个名字之麻烦  阅读(285)  评论(0)    收藏  举报