--sql产生随机数
if exists(select * from sys.objects where name='usp_randCardID')
drop proc usp_randCardID
go
create proc usp_randCardID
@mycardID varchar(19) output
as
declare @rand numeric(15,8),@id varchar(19)
select @rand=RAND((datepart(mm,getdate())*100000)+(datepart(ss,getdate())*1000)+(datepart(ms,getdate())))
select @id='1010 3576 ' + substring(CONVERT(varchar(50),@rand),3,4) +' '+substring(CONVERT(varchar(50),@rand),7,4)
print '产出的随机数为: '+@id
go
declare @mycardID varchar(19)
exec usp_randCardID @mycardID output
go