ConvertTo-EncodedSqlName
Encodes extended characters in SQL Server names to formats usable in Windows PowerShell paths.
语法
Default （默认值）
ConvertTo-EncodedSqlName
[-SqlName] <String>
[<CommonParameters>]
说明
The ConvertTo-EncodedSqlName cmdlet encodes special characters in SQL Server names to formats usable in Windows PowerShell paths.
SQL Server delimited identifiers can contain characters not normally supported in Windows PowerShell object names.
When using delimited identifiers in SQL Server provider paths, these extended characters must be either encoded to their hexadecimal representation or escaped using the ` character.
Certain characters, such as the colon character (:) cannot be escaped.
The hexadecimal encoding for the characters is in the format %nn.
The characters encoded by ConvertTo-EncodedSqlName are: \ : . / % < > * ? [ ] |
示例
Example 1: Encode a SQL Server table name
PS C:\> ConvertTo-EncodedSqlName -SqlName "My:Table/"
My%3ATable%2F
This command encodes a SQL Server table name that contains : and / characters.
参数
-SqlName
Specifies the SQL Server identifier to be encoded.
参数属性
| 类型: | String |
| 默认值: | None |
| 支持通配符: | False |
| 不显示: | False |
参数集
(All)
| Position: | 1 |
| 必需: | True |
| 来自管道的值: | True |
| 来自管道的值（按属性名称）: | True |
| 来自剩余参数的值: | False |
CommonParameters
This cmdlet supports the common parameters: -Debug, -ErrorAction, -ErrorVariable, -InformationAction, -InformationVariable, -OutBuffer, -OutVariable, -PipelineVariable, -ProgressAction, -Verbose, -WarningAction, and -WarningVariable. For more information, see about_CommonParameters.