USE bankDB
GO
SET NOCOUNT ON
--M5B (2)建存储过程pro_randCardID
IF EXISTS(SELECT * FROM sysobjects WHERE name='proc_randCardID')
DROP proc proc_randCardID
GO
CREATE PROC proc_randCardID
@randCardID char(19) OUTPUT
AS
DECLARE @r numeric(15,8)
SELECT @r=RAND(
(DATEPART(mm,GETDATE())*100000)+
(DATEPART(ss,GETDATE())*1000)+
DATEPART(ms,GETDATE())
)
SET @randCardID='1010 3576 '+SUBSTRING(convert(varchar(15),@r),3,4)+' '+SUBSTRING(convert(varchar(15),@r),7,4)
GO
DECLARE @mycardID char(19)
EXEC proc_randCardID @mycardID OUTPUT
print '产生的随机卡号为:'+@mycardID
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/16436858/viewspace-612305/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/16436858/viewspace-612305/