数据库存储过程多用户同时冲突问题解决构思

--得到最新编号的函数
create function f_newid()
returns char(7)   --编号位数固定,用char的检索效率高于varchar
as
begin
    declare @re char(7)
    select @re=max(BHID) from 表(tablockx) --加表级锁
    return(
       case when @re is null then ‘BH00001‘
           else ‘BH‘+right(‘0000‘+cast(cast(right(@re,5) as int)+1 as varchar),5)
       end)
end
go