nvarchar(max) vs NText

by

The advantages are that you can use functions like LEN and LEFT on nvarchar(max) and you cannot do that against ntext and text. It is also easier to work with nvarchar(max) than text where you had to use WRITETEXT and UPDATETEXT.

Also, text, ntext, etc., are being deprecated (http://msdn.microsoft.com/en-us/library/ms187993.aspx)

More Related Contents:

  1. What are the main performance differences between varchar and nvarchar SQL Server data types?
  2. SQL Server query to find all permissions/access for all users in a database
  3. What is the maximum characters for the NVARCHAR(MAX)? [duplicate]
  4. Why use the INCLUDE clause when creating an index?
  5. SQL Server sp_msforeachtable usage to select only those tables which meet some condition
  6. Is it possible to force row level locking in SQL Server?
  7. Regular Expressions in SQL Server servers?
  8. SQL Server GUID sort algorithm. Why?
  9. What happens to the primary key Id when it goes over the limit?
  10. Drop primary key using script in SQL Server database [duplicate]
  11. How to create the linked server for SQL Server 2008 where we have the database from 2000 and 2005
  12. SQL Server recursive query
  13. INFORMATION_SCHEMA vs sysobjects
  14. “Prevent saving changes that require the table to be re-created” negative effects
  15. What are row, page and table locks? And when they are acquired?
  16. Table Valued Function Killing My Query Performance
  17. How to convert text column to datetime in SQL
  18. nvarchar concatenation / index / nvarchar(max) inexplicable behavior
  19. Query times out when executed from web, but super-fast when executed from SSMS
  20. TSQL: How to convert local time to UTC? (SQL Server 2008)
  21. How to determine total number of open/active connections in ms sql server 2005
  22. Find non-ASCII characters in varchar columns using SQL Server
  23. Violation of UNIQUE KEY constraint on INSERT WHERE COUNT(*) = 0 on SQL Server 2005
  24. Restrict an SQL Server connection to a specific IP address
  25. SQL Server Configuration Manager cannot be found
  26. How do I move a table into a schema in T-SQL
  27. How to display two digits after decimal point in SQL Server
  28. Cumulative Total in MS Sql server [duplicate]
  29. Convert UTC Milliseconds to DATETIME in SQL server
  30. @@ERROR and/or TRY – CATCH

Leave a Comment