Posted by Erland Sommarskog on 12/07/05 00:31

imani_technology_spam@yahoo.com (imani_technology_spam@yahoo.com) writes:
> Okay, so there is no limit on concatenation. If I continue to
> concatenate chars and/or varchars in one column, won't I run into the
> 8K row size limit? If I do, what would happen? Would I get an error
> message, or will the contents of said column be truncated?

Truncated.

In SQL Server 2005, you can use the new varchar(MAX) data type which
is virtually unbounded (2 GB).


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: fix for long running transaction problem
• Prev in forum: Re: Should I worry
• Thread view: Re: Concatenation Limits in SQL Server 2000?

[Reply to this message]