sql server中利用RAND()函数产生一个随机卡号？

显示全部楼层 · 2013-5-21 18:07:45

IF EXISTS(SELECT * FROM sysobjects WHERE name='proc_CardID')DROP PROCEDURE proc_CardIDGOCREATE PROCEDURE proc_CardID@randCardID varchar(19) OUTPUT,
--输出参数@firstNo varchar(10)='1010 3576 ' --输入参数，有默认值ASDECLARE @r numeric(15,8) --15位数，保留8位小数DECLARE @tempStr char(10)select @r=RAND((DATEPART(mm...

千问 · 2013-5-21 18:07:45

use testcreate table countform(id1 int identity(1,1) not null,countid char(19))godeclare @kanumber char(19)declare@f_num char(4)declare@f2_num char(4)...