By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,729 Members | 1,490 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,729 IT Pros & Developers. It's quick & easy.

Concatenation Limits in SQL Server 2000?

P: n/a
Is there a limit to how much text you can concatenate (other than data
type limits, of course)? For example, if you write:

SELECT 'This is some text from: ' + Convert(char(15), SomeFieldName01)
+ 'some more text' + Convert(char(25), SomeFieldName02) + 'yet more
text.' As BigNote
FROM Table

Is there a limit on how much you can concatenate into that big note
field, meaning is there a limit other than the size of the data type?

Dec 6 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
>Is there a limit on how much you can concatenate into that big note
field, meaning is there a limit other than the size of the data type?


No.

Dec 6 '05 #2

P: n/a
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?

ZeldorBlat wrote:
Is there a limit on how much you can concatenate into that big note
field, meaning is there a limit other than the size of the data type?


No.


Dec 6 '05 #3

P: n/a
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?

ZeldorBlat wrote:
Is there a limit on how much you can concatenate into that big note
field, meaning is there a limit other than the size of the data type?


No.


Dec 6 '05 #4

P: n/a
im*******************@yahoo.com (im*******************@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, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
Dec 6 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.