有没有办法使用有效的“?"运行插入语句?在里面? [英] Is there a way to run an insert into statement with a valid "?" in it?

问题描述

我正在尝试构建一个 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')

这篇关于有没有办法使用有效的“?"运行插入语句?在里面?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！