REVERSE(SSIS 表达式)REVERSE (SSIS Expression)
适用于:Applies to: SQL ServerSQL Server(所有支持的版本)
SQL ServerSQL Server (all supported versions)
Azure 数据工厂中的 SSIS Integration RuntimeSSIS Integration Runtime in Azure Data Factory
Azure 数据工厂中的 SSIS Integration RuntimeSSIS Integration Runtime in Azure Data Factory
SQL ServerSQL Server(所有支持的版本)
SQL ServerSQL Server (all supported versions)
Azure 数据工厂中的 SSIS Integration RuntimeSSIS Integration Runtime in Azure Data Factory
Azure 数据工厂中的 SSIS Integration RuntimeSSIS Integration Runtime in Azure Data Factory
按相反顺序返回字符表达式。Returns a character expression in reverse order.
语法Syntax
REVERSE(character_expression)
参数Arguments
character_expressioncharacter_expression
是要反转的字符表达式。Is a character expression to be reversed.
结果类型Result Types
DT_WSTRDT_WSTR
备注Remarks
character_expression 参数必须具有 DT_WSTR 数据类型。The character_expression argument must have the DT_WSTR data type.
如果 character_expression 为 Null,则 REVERSE 将返回 Null 结果。REVERSE returns a null result if character_expression is null.
表达式示例Expression Examples
此示例使用一个字符串文字。This example uses a string literal. 返回结果为“ekiB niatnuoM”。The return result is "ekiB niatnuoM".
REVERSE("Mountain Bike")
此示例使用一个变量。This example uses a variable. 如果 Name 包含 Touring Bike,则返回的结果为“ekiB gniruoT”。If Name contains Touring Bike, the return result is "ekiB gniruoT".
REVERSE(@Name)