1 .	Set @xml = ‘<root><key> 1 </key></root>’
 2 .	Set @xml = ‘<root><key> 1 </key><info></info></root>’
 3 .	Set @xml = ‘<root><key> 1 </key><info>ABCDEF…..</info></root>’

@xml.modify(‘insert <info>{sql:variable(“@info”)}</info> as last into (/root)[ 1 ]’)

@xml.modify(‘insert text{sql:variable(“@info”)} as last into (/root/info)[ 1 ]’)

@xml.modify(‘replace value of (root/info[ 1 ]/text())[ 1 ] with sql:variable("@info")’)

declare @xml1 xml
declare @xml2 xml
declare @xml3 xml

Set @xml1 = '<root><key>1</key></root>'
Set @xml2 = '<root><key>1</key><info></info></root>'
Set @xml3 = '<root><key>1</key><info>ABCDEF…..</info></root>'

declare @info varchar( 254 )
set @info = 'MDFT..'

set @xml1.modify('insert <info>{sql:variable("@info")}</info> as last into (/root)[1]')
set @xml2.modify('insert text{sql:variable("@info")} as last into (/root/info)[1]')
set @xml3.modify('replace value of (root/info[1]/text())[1] with sql:variable("@info")')

select @xml1, @xml2, @xml3

set @expression1 = '(root/info[1]/text())[1]'
set @xml3.modify('replace value of {sql:variable("@expression1")} with sql:variable("@info")')

SET @xml.modify(' insert {sql:variable("@expression1")} as last into {sql:variable("@expression2")}')