This error can occur in two instances: CREATE / ALTER TABLE or INSERT/UPDATE. SQL Server Compact Edition does not allow a row length of fixed column to exceed 8060 bytes. However, SQL Server Compact Edition allows a row to exceed a theoretical limit of 8060 bytes using variable length columns (NTEXT/IMAGE) are not included). For instance, a table could be created with 100 NVARCHAR columns with a length of 200 bytes without an error. However, if you use INSERT or UPDATE to modify a row in a column that had a variable length CHAR datatype (NVarChar) that caused the entire row length to exceed 8060 bytes, then this error would occur.
1,将nvarchar改为varchar,如果不是国际文字的话.
2,将那个nvarchar(4000)的字段改为ntext.
3,如果还不行,只有分表而建了.
This error can occur in two instances: CREATE / ALTER TABLE or INSERT/UPDATE. SQL Server Compact Edition does not allow a row length of fixed column to exceed 8060 bytes. However, SQL Server Compact Edition allows a row to exceed a theoretical limit of 8060 bytes using variable length columns (NTEXT/IMAGE) are not included). For instance, a table could be created with 100 NVARCHAR columns with a length of 200 bytes without an error. However, if you use INSERT or UPDATE to modify a row in a column that had a variable length CHAR datatype (NVarChar) that caused the entire row length to exceed 8060 bytes, then this error would occur.