What is difference between ntext and varchar in SQL Server 2008 R2
sql-server-2008-r2
Solution
From ntext, text, and image (Transact-SQL) i think that the biggest difference that should concern you is
ntext, text, and image data types will be removed in a future version of Microsoft SQL Server. Avoid using these data types in new development work, and plan to modify applications that currently use them.
Problem
I want to know basic difference between datatype of `ntext` and `varchar` in SQL Server 2008 R2. And in what situation should I use `ntext` and `varchar`