select 'haha'+Convert(varchar,id) as haid from table 或或select 'haha'+CAST(id as varchar) as haid from table 转载于:https://www.cnblogs.com/luyongqun/archive/2007/04/07/703813.html