Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 is nvarchar(max) better then ntext?

Author  Topic 

esthera
Master Smack Fu Yak Hacker

1410 Posts

Posted - 2010-04-25 : 07:54:06
is nvarchar(max) better then ntext?

which is better to use?

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2010-04-25 : 09:06:21
nvarchar(max)
quote:
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. Use nvarchar(max), varchar(max), and varbinary(max) instead.

http://msdn.microsoft.com/en-us/library/ms187993.aspx


KH
[spoiler]Time is always against us[/spoiler]

Go to Top of Page
   

- Advertisement -