select right('0000000' + cast(max(cast(u_code as int)) as varchar),6) from T
yyzzhy (风信子) 挺有福的 都是高手来帮你回答 哈
1:select right(1000001+cast(cast(max(u_code) as int) as varchar),6) from yourTable 2:select replicate('0',6-len(cast(max(u_code) as int)+cast(cast(max(u_code) as int) as varchar) from yourTable
select substring(convert(char(8),(max(convert(int,u_code))+1)*0.000001),2,7) from yourtable
from T
都是高手来帮你回答
哈
1:select right(1000001+cast(cast(max(u_code) as int) as varchar),6)
from yourTable
2:select replicate('0',6-len(cast(max(u_code) as int)+cast(cast(max(u_code) as int) as varchar)
from yourTable