DECLARE @InDate DATETIME
SET @InDate=GETDATE()
  Declare @Rst varchar(20),@MaxNo int  ,@CurrentDate varchar(20)  
  Select @Rst = '',@MaxNo = 0
  
  --取得当前日期字符串
  Select @CurrentDate = Cast( RIGHT( year(@InDate),2) as varchar) +   --年
                        right('00' + cast(month(@InDate) as varchar),2) + -- 月
                        right('00' + cast(day(@Indate) as varchar),2) +
                        right('00' + cast(DateName(hour,GetDate()) as varchar),2)
                        
      SELECT @CurrentDate         

  Select   @MaxNo = max(cast(right(autoid,4) as int)) From dbo.[order] 
  Where RIGHT( year(@InDate),2) = cast(left(autoid,2) as int)
   and        month(@InDate) = Cast(substring(autoid,3,2) as int) 
   and         day(@InDate) = cast(substring(autoid,5,2) as int) 
        
        --151031100001
        
        SELECT @MaxNo

if (isnull(@MaxNo,0) >0)
Begin
select @Rst = @CurrentDate + right('000' + cast(@MaxNo + 1 as varchar),4)
End
else
Select @Rst = @CurrentDate + '0001'