sql产生随机数--sql产生随机数if exists(select * from sys.objects where name='usp_randCardID')drop proc usp_randCardIDgocreate proc usp_randCardID @mycardID varchar(19) outputas 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 '产出的随机数为： '+@idgodeclare @mycardID varchar(19)exec usp_randCardID @mycardID outputgo
