SQL “CONCAT”不是可识别的内置函数名称。使用内部连接更新事务
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/37534753/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
'CONCAT' is not a recognized built-in function name. Update transaction with Inner Join
提问by Thamires Cunha
I set up a query to get to update on a table field(sql server) by concatenating other fields.
我设置了一个查询，通过连接其他字段来更新表字段（sql server）。
My query
我的查询
UPDATE ORDER O
SET O.COD_MODEL_ORDER = CONCAT(M.COD_MODEL, '-', O.COD_ORDER)
INNER JOIN MODEL M ON M.ID_MODEL = O.ID_MODEL
WHERE ID_ORDER = 5;
Error:
错误：
'CONCAT' is not a recognized built-in function name.
“CONCAT”不是可识别的内置函数名称。
Where am I going wrong?
My objective is to join Model and Order.
Update Order field concatenating two other fields:
我哪里错了？
我的目标是加入 Model and Order。
更新订单字段连接另外两个字段：
- COD_MODEL(varchar) FROM MODEL
- COD_ORDER(varchar) FROM ORDER
- COD_MODEL(varchar) FROM MODEL
- COD_ORDER(varchar) FROM ORDER
回答by mhn
Why not simply concatenate using +
为什么不简单地使用 + 连接
UPDATE O
SET O.COD_MODEL_ORDER = M.COD_MODEL + '-' + O.COD_ORDER
FROM ORDER O
INNER JOIN MODEL M ON M.ID_MODEL = O.ID_MODEL
WHERE ID_ORDER = 5;
