/*--自动生成卡号
if exists (select name from sysobjects where name='trig_insert_cardinfo')
drop trigger trig_insert_cardinfo
go
create trigger trig_insert_cardinfo
on cardinfo
for insert
as
create table codes(code varchar(20))
create table d3
(
[rnum] varchar(50)
)
declare @i int
set @i=ascii('0')
while @i<=ascii('9')
begin
insert d3 select char(@i)
set @i=@i+1
end
declare @tmp varchar(100),@w int,@c int ,@str varchar(100),@tr varchar(10),@moren varchar(10)
set @tmp=''
set @w=1--新加
set @c=1
set @tr=' '
set @str=''
while @c<=2
begin
while @w<=4
begin
select @tmp=@tmp+rnum from (select top 1 rnum from d3 order by newid())A
set @w=@w+1
end
set @tmp=@tmp+@tr
set @c=@c+1
set @w=1
end
set @moren='1010 3576'
set @tmp=@moren+@tr+@tmp
insert codes(code) select @tmp
select * from codes
declare @cardid varchar(20)
select @cardid=code from codes
print '你的卡号是:'+@cardid
update cardinfo set cardid=@cardid from cardinfo where opendate=(select max(opendate) from cardinfo)
drop table d3,codes
*/--自动生成卡号