1-) MSSQL RMOS - Büyük Boyutlu Tüm Veriyi Çekmek How do you view ALL text from an ntext or nvarchar max in SSMS

kaynak : https://stackoverflow.com/questions/11897950/how-do-you-view-all-text-from-an-ntext-or-nvarcharmax-in-ssms

SELECT CAST('<![CDATA[' + CAST(LogInfo as nvarchar(max)) + ']]>' AS xml)

FROM Logs

WHERE IDLog = 904862629

SELECT CAST('<![CDATA[' + CAST(json as nvarchar(max)) + ']]>' AS xml)

FROM entegreJson

WHERE id = 44