问题描述
我正在尝试构建一个 insert into 语句，该语句将包含一个具有有效?"的 URL 字符串.在其中.我正在使用 Teradata SQL Assistant (Windows XP)，它正在尝试将其转换为参数.
I am trying to build an insert into statement that will include a URL string which has a valid "?" in it. I am using Teradata SQL Assistant (Windows XP) and it is trying to translate this into a parameter.
有没有办法覆盖它并将其视为字符值?
Is there any way to override this and treat it as a character value?
示例网址:https://www.location.com/livelink.exe?func=ll
推荐答案
转到 Tools -> 上的 Query 选项卡选项... 页并取消选中标记为允许在查询中使用命名参数"的框.以下是我使用的设置:
Go to the Query tab on the Tools -> Options... page and uncheck the box labeled "Allow use of Named Parameters in queries". Here are the settings I use:
这将防止问号被视为提示并处理如下插入语句:
That will prevent question mark from being treated as prompts and process an insert statement like this:
insert into yourdb.yourtable
(url)
values ('https://www.location.com/livelink.exe?func=ll')
这篇关于有没有办法使用有效的“?"运行插入语句?在里面?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！