REVERSE(SSIS 表达式)REVERSE (SSIS Expression)

适用于:Applies to: 是SQL ServerSQL Server(所有支持的版本)yesSQL ServerSQL Server (all supported versions) 是 Azure 数据工厂中的 SSIS Integration RuntimeSSIS Integration Runtime in Azure Data Factoryyes Azure 数据工厂中的 SSIS Integration RuntimeSSIS Integration Runtime in Azure Data Factory适用于:Applies to: 是SQL ServerSQL Server(所有支持的版本)yesSQL ServerSQL Server (all supported versions) 是 Azure 数据工厂中的 SSIS Integration RuntimeSSIS Integration Runtime in Azure Data Factoryyes 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)  

另请参阅See Also

函数(SSIS 表达式)Functions (SSIS Expression)