Database Help Framework Functions
Function | Description |
---|---|
doc.get_escaped_parameter_name | This function returns an escaped parameter name. |
doc.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.