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 vote120 views1 answer
Check user sql password from command line
SQL
3 votes121 views2 answers
Wp do sql query from function
SQL
2 votes120 views1 answer
Q operator in plsql
SQL
0 vote122 views1 answer
Make a socket server to detect changes in mysql
SQL
0 vote120 views1 answer
Rename constraint postgresql
SQL
1 vote128 views1 answer
Partition by sql server
SQL
0 vote122 views1 answer
Get time component of datetime sql
SQL
24 votes123 views6 answers
Sql change table name
SQL
0 vote110 views1 answer
T sql check active deadlock
SQL
5 votes125 views2 answers
Oracle rename table
SQL