gpt4 book ai didi

sql - XML 数据类型方法 “value” 必须是字符串文字

转载 作者:数据小太阳 更新时间:2023-10-29 01:43:00 25 4
gpt4 key购买 nike

<分区>

如何更改我的查询以便不会发生此错误:

XML data type method “value” must be a string literal

T-SQL 代码:

Declare @Count Int = 1 
While(@count <= @j)
Begin
insert into mytable
([Word])
Select ([XmlColumn].value(N'word['+Cast(@Count as nvarchar(2))+']/@Entry','nvarchar(max)'))
from OtherTable WHERE ID=2

25 4 0
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com