/*卡号随机产生*/
create proc proc_randmon
(
@outID varchar(19) output --要生成的卡号
)
as
declare @inID varchar(19)
set @inID='6225 8802'
declare @randmon numeric(18,16) --随机生成的卡号
set @randmon=rand(datepart(dd,getdate())*10000+datepart(ss,getdate())*1000+datepart(ms,getdate()))
set @outID=@inID+' '+substring((convert(varchar,@randmon)),3,4)+' '+substring((convert(varchar,@randmon)),7,4)
go
declare @randNum varchar(19)
exec proc_randmon @randNum output
print '生成的卡号:'+convert(varchar,@randNum)