end
begin

ALTER function [dbo].[GetOrderNum](

end
declare @max varchar(100)
SELECT * FROM tb_EbayOrderList WITH (TABLOCKX)

begin set @num='0'+@num end
declare @flag varchar(20)
set @num=Convert(varchar,SUBSTRING(@a,3,LEN(@a-2))+1)
else begin --数字大于100的情况

复制代码 代码如下:

调用：在事务中先锁定要操作的表
set @a=Convert(varchar,right(@max,len(@max)-10))--截取数字部分
begin set @num='00'+@num end
end

SELECT @max=MAX(OrderNumber)
returns varchar(100)
SELECT * FROM tb_EbayOrderUserInfo WITH (TABLOCKX)
)
else if(SUBSTRING(@a,3,1)=0 and SUBSTRING(@a,2,1)=0)--有三个0
end

调用：select dbo.GetOrderNum(@ebaystockflag) declare @a varchar(100)

set @max=isnull(@max, @flag+@dt+'000')--查不到结果给个默认值
begin
declare @ordernum varchar(20)
begin
if(LEN(@num)=1)--截取后不满三位的补0
if(SUBSTRING(@a,2,1)=0)--有两个0
return @ordernum
set @num=Convert(int,SUBSTRING(@a,2,LEN(@a))+1)
declare @dt CHAR(8)
set @ordernum=@flag+@dt+@num
if(LEFT(@a,1)=0)--以0开头

end
else begin --只有一个0的情况
set @flag='B'+@ebaystockflag
declare @num varchar(10)
BEGIN
SELECT * FROM tb_EbayOrder WITH (TABLOCKX)
END
if(LEN(@num)=2)
@ebaystockflag varchar(20)//规则字母

复制代码 代码如下:

WHERE OrderNumber like @flag+'%'
AS
set @num=1
set @num=Convert(varchar,@a+1)
FROM tb_EbayOrder WITH(XLOCK,PAGLOCK)

set @dt=CONVERT(CHAR(8),GETDATE(),112)