sql 字段拼接字符串的方法 SELECT 'x' + CAST(ID AS varchar) AS Expr1 FROM dbo.qk_xkb 转载于:https://www.cnblogs.com/fengju/archive/2010/08/05/6173790.html