Declare @S nvarchar(10)
Set @S = '小二'
Update T Set M.modify('replace value of (/root/BookName/text())[1] with "{sql:variable("@S")}"') Where ID = 5
...全文
1412打赏收藏
修改XML数据时出错
SQL 2005 语句如下: Declare @S nvarchar(10) Set @S = '小二' Update T Set M.modify('replace value of (/root/BookName/text())[1] with "{sql:variable("@S")}"') Where ID = 5