Home Forums SQL Server 2005 T-SQL (SS2K5) DISTINCT in a SQL statements with a TEXT field RE: DISTINCT in a SQL statements with a TEXT field

  • August 12, 2008 at 11:25 am

    #856909

    Thanks for the feedback, Mark.

    Varchar(MAX) is one of the best things about SQL Server 2005, completely gets rid of the need for the BLOB's (Text, NText, etc.), meaning no more messy special functions and commands just to manipulate TEXT columns, no more mysterious failures that turn out to be because TEXT is not supported in that context (replication, etc.).

    IMHO, this alone is reason enough to upgrade to SQL 2005.

    [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
    Proactive Performance Solutions, Inc.     [/font]    [font="Verdana"] "Performance is our middle name."[/font]