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