将xquery命令作为varchar传递 [英] Passing xquery command as varchar

问题描述

请让我知道将以下命令（包括column.value）作为varchar传递给select查询命令的方法



column.value（'declare namespace xc =value;（// xc：value1/ xc：childnode1 / xc：childnode2）[1] / @ val1'，'varchar（200）'）



我尝试了什么：



我尝试了几种方法 - 但仍然出现语法错误

Please let me know the way to pass the below command (including column.value) as varchar to the select query command

column.value('declare namespace xc="value";(//xc:"value1"/xc:childnode1/xc:childnode2)[1]/@val1', 'varchar(200)')

What I have tried:

I have tried several ways - but still getting syntax error

推荐答案

我不确定，但听起来你的报价有问题。例如，这是无效的：

I'm not sure, but it sounds like you're having problems with quotes. For example, this isn't valid:

select foo from bar where baz='I'm not sure'

单引号在SQL中分隔一个字符串，因此如果你想要一个带单引号的字符串，你必须通过加倍单引号来转义它们。

Single quotes delimit a string in SQL, so if you want a string with single quotes in it, you must escape them by doubling the single quotes.

select foo from bar where baz='I''m not sure'

这篇关于将xquery命令作为varchar传递的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！