CONCAT (Azure Cosmos DB)CONCAT (Azure Cosmos DB)
适用于:
SQL API
返回一个字符串,该字符串是连接两个或多个字符串值的结果。Returns a string that is the result of concatenating two or more string values.
语法Syntax
CONCAT(<str_expr1>, <str_expr2> [, <str_exprN>])
参数Arguments
str_exprstr_expr
是要连接到其他值的字符串表达式。Is a string expression to concatenate to the other values. CONCAT
函数需要至少两个 str_expr 参数。The CONCAT
function requires at least two str_expr arguments.
返回类型Return types
返回一个字符串表达式。Returns a string expression.
示例Examples
以下示例返回将指定值串联后形成的字符串。The following example returns the concatenated string of the specified values.
SELECT CONCAT("abc", "def") AS concat
下面是结果集。Here is the result set.
[{"concat": "abcdef"}]
备注Remarks
此系统函数不会使用索引。This system function will not utilize the index.