F
Size: a a a
F
F
G
G
F
L
G
G
F
F
G
Дt
Дt
MC
declare @a xml = '<product><preply><report><AccountReply><creditTotalAmt>"32"</creditTotalAmt></AccountReply></report></preply></product>'
select @a.query('data(/product/preply/report/AccountReply/creditTotalAmt)[1] instance of xs:string')
, @a.query('data(/product/preply/report/AccountReply/creditTotalAmt)[1] instance of empty()')
, @a.query('data(/product/preply/report/AccountReply/creditTotalAmt)[1]')
L
declare @a xml = '<product><preply><report><AccountReply><creditTotalAmt>"32"</creditTotalAmt></AccountReply></report></preply></product>'
select @a.query('data(/product/preply/report/AccountReply/creditTotalAmt)[1] instance of xs:string')
, @a.query('data(/product/preply/report/AccountReply/creditTotalAmt)[1] instance of empty()')
, @a.query('data(/product/preply/report/AccountReply/creditTotalAmt)[1]')