Database Help Framework
for Microsoft SQL Server
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.