SQL随机卡号

--产生随机账号存储过程
if(exists(select * from sysobjects where name='RandCardId'))
drop proc RandCardId
go
create proc RandCardId
@Id varchar(50) output
as
DECLARE @num numeric(15,8)
set @Id='1010 3576 '
         --月 秒 毫秒
set @num= (rand(month(GETDATE())*1000+ datepart(ss,getdate())*1000+datepart(ms,getdate())*1000))
set @Id=@Id+ substring(cast(@num as varchar(50)),3,4)+' '+substring(cast(@num as varchar(50)),6,4)
declare @mycarID varchar(60)
exec RandCardId @mycarID output
print '产生随机卡为：'+@mycarID
 
 
--洪浩洋
if (exists (select * from sysobjects where name='hong'))
drop proc hong
go
create proc hong
@Id varchar(50) output
as
set @Id='1010 1212'+' '
set @Id=@Id+substring(convert(varchar(50),Rand()),3,4)+' '+substring(convert(varchar(50),Rand()),3,4)
declare @Id varchar(50)
exec hong @Id output
print '你的随机卡号为'+@Id
 
 
-- print month(GETDATE())*1000
-- print (rand(month(GETDATE())*1000+ datepart(ss,getdate())*1000+datepart(ms,getdate())*1000))
--print substring(convert(varchar(50),Rand()),3,4)+' '+substring(convert(varchar(50),Rand()),3,4)
--print datepart(ms,(getdate())) --毫秒
--print datepart(day,(getdate()))--天
--print datepart(year,(getdate()))--年
--print datepart(month,(getdate()))--月
-- print datepart(ss,getdate())--秒