S***k
发帖数: 370 | 1 昨天xml type methods 出错, 执行 SET QUOTED_IDENTIFIER OFF 后就好了.把它设成
ON 能重复这个xml type methods 执行错误.
今天, 无论这个option 是ON 还是OFF, 都不出错了.
还有其它的 option 会影响xml type methods 的执行吗? | B*****g
发帖数: 34098 | 2 you may want to share us with:
SQL Server version
Table main structure
you sql or tsql
成
【在 S***k 的大作中提到】
: 昨天xml type methods 出错, 执行 SET QUOTED_IDENTIFIER OFF 后就好了.把它设成
: ON 能重复这个xml type methods 执行错误.
: 今天, 无论这个option 是ON 还是OFF, 都不出错了.
: 还有其它的 option 会影响xml type methods 的执行吗?
| S***k
发帖数: 370 | 3 server 2008 with compatibility level 90.
the structure is a column with xml type.
In the stored procedure, the query likes:
update table
set xmlColumn.modify('replace value of (/blah/blah[data(.) = sql:variable("@
oldvalue")])[1] with sql:variable("@newValue")')
Suppose, the QUOTED_IDENTIFIER is a procedure specified option. In theory,
the option should be set to "ON" to use xml type methods.
What happened yesterday was if run "SET QUOTED_IDENTIFIER ON" as a query, or
alter another procedure with "SET QUOTED_IDENTIFIER ON", the execution of
the procedure with xml type methods failed. If I run "SET QUOTED_IDENTIFIER
OFF" as a query, then the execution of the procedure went though without any
issue.
This is really odd to me. Unfortunately, I could not replicated it anymore.
I am not the only one with admin permission on that sql server. It makes me
very confused, in what kind of situation set
QUOTED_IDENTIFIER option could be globalized to reset all procedures in the
database, and in what situation the quoted_identifier should be set to OFF
for xml type methods?
【在 B*****g 的大作中提到】
: you may want to share us with:
: SQL Server version
: Table main structure
: you sql or tsql
:
: 成
| i****a
发帖数: 36252 | 4 look at yesterday's data. there must be a quote somewhere in the data |
|
