@today datetime,
@tmpprenum varchar(4),
@tmpword varchar(2),
@year1 varchar(2),
@day1 varchar(2),
@month1 varchar(2)
set @today = getdate()
if not exists(select frecord from tbrecno where frecord=@precrecord) --若表中没有与参数1同名的则新插入一条
begin
insert into tbrecno (frecord,predate,prenum,word) values(@precrecord,@today,1,left(@precrecord,2))
end
else
begin
select @prctmpdate=predate from tbrecno where frecord=@precrecord
