DECLARE @x xml SET @x='' -- Following will not work -- SELECT @x.query('2 idiv 2') -- Workaround SELECT @x.query('xs:integer(2 div 3)') The resulting type from an arithmetic operator is based on the ...
Note that, for compatibility with previous versions, there is no automatic escalation of results involving LONG data types to LOB data types. For example ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results