Sql server select value large text

SELECT CONVERT(XML, [column_here]) AS [Value]
FROM [TABLE] 

SELECT CAST('<![CDATA[' + CAST(column_here as nvarchar(max)) + ']]>' AS XML) FROM [TABLE]

Similar codes

0 vote108 views1 answer
Postgres jsonb array push new element
SQL
0 vote122 views1 answer
Postgres grep entire database
SQL
0 vote115 views1 answer
Mysql backup certain tables workbench
SQL
0 vote105 views1 answer
Datagrip exec
SQL
1 vote103 views1 answer
Mysql connect command
SQL
0 vote113 views1 answer
How to add boolean column in postgresql
SQL
0 vote97 views2 answers
Get top 1 row of each group
SQL
0 vote102 views1 answer
Error code 1241 mysql
SQL
2 votes108 views1 answer
Oracle drop table free up space
SQL
0 vote107 views1 answer
Object Information
SQL