解释一下！
各位，本鸟读懂该段实有难度，恳请诸位高手帮忙解释下！附上演示实例。谢谢！


select @equipment_id = rtrim(Convert(char(3),Convert(int,substring(max(equipment_id),4,3))+1)) from tb_er_equipment
select @equipment_id = 'VIS'+REPLICATE('0', 3 - datalength(rtrim(@equipment_id)))+rtrim(@equipment_id)





[解决办法]
rtrim(Convert(char(3),Convert(int,substring(max(equipment_id),4,3))+1))

max(equipment_id) 取最大值
substring(max(equipment_id),4,3) 截字符串，从第四个开始，截三个

Convert(int,substring(max(equipment_id),4,3))+1)
截出来的字符串 转换 INT 然后+ 1

Convert(char(3),Convert(int,substring(max(equipment_id),4,3))+1))
转换为 char 类型



REPLICATE('0', 3 - datalength(rtrim(@equipment_id)))+rtrim(@equipment_id)

rtrim(@equipment_id) 去空格
datalength(rtrim(@equipment_id)) 取长度
REPLICATE('0', 3 - datalength(rtrim(@equipment_id)))

返回一个值，如000000,0的位数，决绝于 3 - datalength(rtrim(@equipment_id))


rtrim(@equipment_id) 去空格