Has the SQL Sever 2005 the 8060 chars row length limit for tables?

Question

Has the SQL Sever 2005 the 8060 chars row length limit for tables?

jf-239130

SSC Rookie

Points: 31
More actions
June 22, 2005 at 9:25 am

#86651

Do you know whether SQL Sever 2005 has also the 8060 chars row length limit for tables? If you intalled some beta, you could check the online books => create table -> Remarks

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

DCPeterson SSCoach Points: 15266 More actions · Answer 1

Yes, and no. The 8060 limit still applies to tables with fixed width columns, but if you have variable length data types in your table you can get around this limit. The combined total length of your fixed width columns must still be less than 8060 bytes though.

Oh, and your standard varchar, nvarchar, and varbinary data types are still limited to 8000 bytes each.

/*****************

If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek

*****************/