转自:http://blog.163.com/liufupanhao@126/blog/static/1284651702011112103955737/
SELECT parent_id_list+','+cast(id AS varchar(10)) FROM mytable
或者cast也可以用convert来代替
同时看到有网友有这样的需求,它想把1转成varchar的”000001″这样的串,但是cast函数是只会转成”1″,所以要借用right函数
select right(’00000000′ CAST(@i as varchar),