复制udf_SeriesNumber SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE FUNCTION [dbo].[udf_SeriesNumber] ( @Number NVARCHAR(12),数使用 --原来的值 @Digit INT --流水号的亿华云计算位数 ) RETURNS NVARCHAR(100) AS BEGIN DECLARE @ReturnValue NVARCHAR(100) IF (@Number IS NULL) SET @ReturnValue = REPLICATE(0, @Digit - 1) + 1 ELSE BEGIN DECLARE @nbr NVARCHAR(6) SET @nbr = CONVERT(NVARCHAR,(CONVERT(INT, RIGHT(@Number, @Digit)) + 1)) SET @nbr = REPLICATE(0, @Digit - LEN(@nbr)) + @nbr SET @ReturnValue = @nbr END RETURN @ReturnValue END 1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.20.21.22.23.24.25.26.b2b供应网