What's the difference between ntext and nvarchar(max) in sqlserver????

Question

Kirtan Patel · Answer

Difference Between NTEXT and NVARCHAR is that NTEXT is Old One and NVARCHAR is new one Ntext Stores text As LOB ( Large Object Structure ) in database while NVARCHAR behaves by default store text in table structure and behaves like NTEXT (LOB Structure ) only when it exceeds 8000 Bytes . so better to use NVARCHAR() if it solves your doubt please mark Do you like this answer  check box :)

Lalit M · Answer

You will get more idea practically here

Hirendra Sisodiya · Answer

thanks Kirtan