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.