字段连接select语句

select 'haha'+Convert(varchar,id) as haid
from table
或或select 'haha'+CAST(id as varchar) as haid
from table