end
select @day1= --取出天数，若不够两位的补够两位
case len (ltrim(str(day(@prctmpdate))))
when 1 then '0'+ltrim(str(day(@prctmpdate )))
when 2 then ltrim(str(day(@prctmpdate )))
end
----------------------------------------------------------------------------------------------------------------
if @sign=1
begin --判断输出类型
set @primarykey =rtrim(ltrim(@tmpword))+ @tmpprenum
end
