Generate serial Number

/* AUTHOR:YUCL

Createdate:2015-09-28

Functionname:functaskno

Remark:description: Get Task number

version:v1.0 * *

ALTER FUNCTION Functaskno

(@TaskNO varchar (30))

Returns varchar (a) BEGIN

DECLARE @TaskNewNo varchar (30)

DECLARE @TaskMaxNo varchar (30)

-Get the final training mission released today

SELECT @TaskMaxNo =max (taskno) from Traintaskinfo

where Convert (varchar), createtime,120) =convert (varchar), GETDATE (), 120)

DECLARE @CurDate varchar (16)

SELECT @CurDate =replace (replace (CONVERT (varchar), GETDATE (), 120), '-', '), ': ', ', ')

--a release mission today

IF (Len (@TaskMaxNo) <> ")

Begin

Select @TaskNewNo =substring (@TaskMaxNo, LEN (@TaskMaxNo) -4,4)

Select @TaskNewNo =right (CONVERT (int, @TaskNewNo) +1,4)

End

--No tasks released today

ElSE

BEGIN

Select @TaskNewNo =right (' 1 ', 4)

END

Select @[email Protected][email protected]

Return @TaskNewNo

END

GO

Generate serial Number