int类型转换为varchar
cast(ID as varchar)
update TableName set path=cast(ID as varchar)+'.txt'
把表中的path字段改为表中的id字段+.txt