生成简历编号(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