生成简历编号(eg.RE00000XXXX)

  简历编号生成函数：sqlServer标量值函数

/*
   Author:兴百放
   DateTime : 2007-10-15
*/
Create   Function  Job_GetREID( @PKId   int )
returns    varchar ( 50 )
Begin
    declare   @TempValue   int
    declare   @REID   varchar ( 50 )
    declare   @CurrentDate   varchar ( 50 )
    set   @PKId = @PKId
    set   @CurrentDate   =   Convert ( varchar ( 50 ), getdate (), 112 )
    set   @TempValue   =   100000000 + @PKId
    set   @REID   =   substring ( cast ( @TempValue   as   varchar ( 20 )), len ( cast ( @TempValue   as   varchar ( 20 ))) - 7 , 8 )
    set   @REID   = ' RE ' + @REID     -- RE00000XXX
    -- set @REID ='RE'+@CurrentDate+@REID --RE2007101500000XXX
    return   @REID
End

调用如下：
Select dbo.Job_GetREId(10)
输出：
RE00000010

转载于:https://www.cnblogs.com/xbf321/archive/2007/10/15/924544.html