sqlServer 函数

sqlServer 函数

 

ALTER FUNCTION [dbo].[IM_fn_SRNO](@reg VARCHAR(64),@inv VARCHAR(64))
RETURNS [varchar](256) WITH EXECUTE AS CALLER
AS
begin
declare @Name varchar(256)
declare @regNew varchar(256)
select @Name =rnum from (  select row_number() over(ORDER BY INVOICECODE) as rnum ,  INVOICECODE  
from  CM_FAREDETAIL  where regcode = @reg group by INVOICECODE  )  t where t.INVOICECODE =@inv

if @name >1
BEGIN
  set @regNew = @reg +'00' + @name
END
ELSE
BEGIN
    set @regNew = @reg
END

    return @regNew
    END