Post reply

What about discontinued use of text, ntext, and image

  • February 24, 2009 at 10:18 am

    #384007

    I stumbled across the following link: http://msdn.microsoft.com/en-us/library/ms187993.aspx. Basically, they're stating that 'at some point', the text, ntext, and image data types will be removed in a future version. Not deprecated, but still, discontinued (http://msdn.microsoft.com/en-us/library/ms143729.aspx). As a rule, do items that have discontinuance notifications posted become deprecated on the next version?

    Tom

  • February 24, 2009 at 12:35 pm

    #949593

    I think the reasoning is because all three are replaced by Varchar(max), Nvarchar(max) and Varbinary(max) these newer versions comes with options to use in row for any insert under 8k and most important can be used for comparison and other functions not used with Text, Ntext and image. So they are replaced or changed as of SQL Server 2005.

    Kind regards,
    Gift Peddie

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply