Monday, March 19, 2012

How to create a row that has size greater than 8060

Hi all
When I updated database I got the error message that size of row can't
greater than 8060. Howerver, I think there must be a solution because 8060
is too small. Help me!
ThanksHi
You can ignore the error message and the table will be created although if
the data inserted into the table exceeds the size then the insert will fail.
A table with a size greater than 8060 is a very wide table and you may want
to think about re-designing the database so that you use several tables. You
can create a view that joins these tables if you always wish to avoid joinin
g
the tables "manually".
John
"ghostnguyen" wrote:

> Hi all
> When I updated database I got the error message that size of row can't
> greater than 8060. Howerver, I think there must be a solution because 8060
> is too small. Help me!
> Thanks
>
>|||And all this really, really, really needs to be in a single table? Can you
post some DDL, please?
ML|||Size of a Single row cannot be more than 8060 bytes
Madhivanan|||Create two tables related by a common primary key.
David Portas
SQL Server MVP
--|||Short of redesigning your table (using two tables, for example, as has been
suggested), you may want to consider using [text] instead of long [varchar]
columns. They will be harder to work with, but they are one way to get
around this limitation.
Steve Kass
Drew University
ghostnguyen wrote:

>Hi all
>When I updated database I got the error message that size of row can't
>greater than 8060. Howerver, I think there must be a solution because 8060
>is too small. Help me!
>Thanks
>
>|||If 8060 is too small, seriously look at your database design, or use
datatypes like ntext if you need large text storage.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:DB030F6E-7BA3-4187-817E-EA3FF8088575@.microsoft.com...
> Hi
> You can ignore the error message and the table will be created although if
> the data inserted into the table exceeds the size then the insert will
> fail.
> A table with a size greater than 8060 is a very wide table and you may
> want
> to think about re-designing the database so that you use several tables.
> You
> can create a view that joins these tables if you always wish to avoid
> joining
> the tables "manually".
> John
> "ghostnguyen" wrote:
>

No comments:

Post a Comment