Contents Diagrams Roles Schemas Tables Views Procedures Functions

Change Tracking Framework
for Microsoft SQL Server

Functions

FunctionDescription
logs.get_escaped_parameter_nameThis function returns an escaped parameter name.
logs.get_translated_stringThis function returns a translated string.
logs.get_unescaped_parameter_nameThis function returns an unescaped parameter name.

logs.get_escaped_parameter_name

This function returns an escaped parameter name.

ParameterDataTypeComment
Resultnvarchar(255)Escaped parameter name
@namenvarchar(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.

ParameterDataTypeComment
Resultnvarchar(128)The value from the logs.translations table
@stringnvarchar(128)String to translate
@data_languagechar(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.

ParameterDataTypeComment
Resultnvarchar(128)Unescaped column name
@namenvarchar(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.

Contents

This website is using cookies. By continuing to browse, you give us your consent to our use of cookies as explained in our Cookie Policy.