01.create function NextOrderNumber()
02.returns char(8)
03.as
04.begin
05. declare @lastval char(8)
06. declare @curyear char(4)
07. set @curyear = 'OR' + (select right(YEAR(getdate()),2))
08. set @lastval = (select MAX(orderNumber) from [PROJ].[dbo].[ZTemp001] where orderNumber like '%' + @curyear + '%')
09. if @lastval is null set @lastval = (@curyear + '0000')
10. declare @i int
11. set @i = convert(integer,RIGHT(@lastval,4)) + 1
12. return @curyear + right('000' + convert(varchar(10),@i),4)
13.end
จัดไปครับ
