mssql 生成随机不重复密码
2009-09-27 By im502 [0] 315 views

公司需要做一批充值卡，类似中国移动手机充值卡那样的，要求生成的密码还不能重复，用sqlserver来生成以下，语句如下：

?View Code SQL
set   nocount   on   
  declare   @tt   table   (id   int)   
  declare   @i   int   
  select   @i=1   
  while   @i<=10000   
  begin   
  insert   into   @tt   values   (@i)   
  select   @i=@i+1   
  end   
 
  select   right(cast(abs(checksum(newid()))   as   varchar)+cast(abs(checksum(newid()))   as   varchar),12)     as   card_pass  into   #temp   from   @tt   
 
  select   *   from   #temp