When trying to extract data from a text or image field, it is not always clear, how many bytes of data can be expected. Here’s a way how to determine this:
1> SET textsize 1669842
2> go
1> SELECT Xml FROM TradeXml WHERE AsOfDate = ‘20091019′ AND TradeId = ‘xxxxxxx’
2> go
In order to determine the value that needs [...]