Change Tracking Framework
for Microsoft SQL Server
Functions
Function | Description |
---|---|
logs.get_escaped_parameter_name | This function returns an escaped parameter name. |
logs.get_translated_string | This function returns a translated string. |
logs.get_unescaped_parameter_name | This function returns an unescaped parameter name. |
logs.get_escaped_parameter_name
This function returns an escaped parameter name.
Parameter | DataType | Comment |
---|---|---|
Result | nvarchar(255) | Escaped parameter name |
@name | nvarchar(128) | Column name |
The function converts special characters using the _xHHHH_ format, where HHHH is the hexadecimal character code.
For example, it converts a single quote to _x0027_.
You may use such parameter names in the procedures and handlers that get values from the Excel table columns.
The SaveToDB add-in uses the same conversion function to link columns and parameters.
logs.get_translated_string
This function returns a translated string.
Parameter | DataType | Comment |
---|---|---|
Result | nvarchar(128) | The value from the logs.translations table |
@string | nvarchar(128) | String to translate |
@data_language | char(2) | Target language |
The function uses the log.translations table to translate strings.
logs.get_unescaped_parameter_name
This function returns an unescaped parameter name.
Parameter | DataType | Comment |
---|---|---|
Result | nvarchar(128) | Unescaped column name |
@name | nvarchar(255) | Escaped parameter name |
The function converts escaped parameter names with the _xHHHH_ format into the regular column names.
For example, it converts the _x0027_ value to a single quote.