Difference between nvarchar(max) and NText

Now, I'm a beginner using SQL Server and I'm looking to learn more about the advantages / disadvantages between "nvarchar(max)" and "NText" data types. Now, I don't need to know backward compatibility so I already know that "nvarchar(max)" isn't supported by previous SQL Server releases.

ITKE1,149,950 pointsBadges:

Retrieving specific XML data in SQL Server

I have a question regarding SQL Server. I have a table with an ntext datatype column where I am storing XML data. My question is: How do I write a user-defined function to retrieve a particular xml attribute in that column?

SQL Server Ask the Experts2,585 pointsBadges: