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
原文:https://www.cnblogs.com/leolzi/p/15194159.html
如果您也喜欢它,动动您的小指点个赞吧