如果已经存在用户名 则自动生成一个用户名使用用户名加数字
declare @oid nvarchar(50)
set @oid="huangf"
select top 1 ISNULL(oid,""),SUBSTRING(oid,LEN(@oid )+1,LEN(oid )),case ISNUMERIC(SUBSTRING(oid,LEN(@oid )+1,LEN(oid ))) when 1 then CONVERT(int,SUBSTRING(oid,LEN(@oid )+1,LEN(oid ))) else 0 end as num from AOinfo where oid like @oid+"%"
order by num desc
set @oid="huangf"
select top 1 ISNULL(oid,""),SUBSTRING(oid,LEN(@oid )+1,LEN(oid )),case ISNUMERIC(SUBSTRING(oid,LEN(@oid )+1,LEN(oid ))) when 1 then CONVERT(int,SUBSTRING(oid,LEN(@oid )+1,LEN(oid ))) else 0 end as num from AOinfo where oid like @oid+"%"
order by num desc
声明：该文观点仅代表作者本人，牛骨文系教育信息发布平台，牛骨文仅提供信息存储空间服务。
