Tuesday, March 20, 2012

ROW Limit and pages

OK I just need a clarification:
SO the total size of the combined columns in a table for one row cannot
exceed 8k correct? (Throwing out the TEXT, NCHAR and NTEXT data types)
Thank you in advance!
MikeYes,
But its 8038
Yours in quibble
Peter
"Do not awake the sleeping dragon for you are crunchy and
taste good with ketchup".
Peter The Spate
>--Original Message--
>OK I just need a clarification:
>SO the total size of the combined columns in a table for
one row cannot
> exceed 8k correct? (Throwing out the TEXT, NCHAR and
NTEXT data types)
>Thank you in advance!
>Mike
>.
>|||On Mon, 22 Nov 2004 12:17:59 -0500, Mike London wrote:
>OK I just need a clarification:
>SO the total size of the combined columns in a table for one row cannot
> exceed 8k correct? (Throwing out the TEXT, NCHAR and NTEXT data types)
>Thank you in advance!
Hi Mike,
NCHAR should be counted in, IMAGE should be thrown out (as well as TEXT
and NTEXT) (but do check out the text in row option).
Best, Hugo
--
(Remove _NO_ and _SPAM_ to get my e-mail address)|||Thank you both for that clarification!
Mike London wrote:
> OK I just need a clarification:
> SO the total size of the combined columns in a table for one row cannot
> exceed 8k correct? (Throwing out the TEXT, NCHAR and NTEXT data types)
> Thank you in advance!
> Mike

No comments:

Post a Comment