Hi
I've a table with 4000 records and following structure,
and sometime I've got an error like below why?
CREATE TABLE [ENPARTT] (
[ENPART_COD] [char] (6) COLLATE SQL_Latin1_General_CP1256_CI_AS NOT NULL ,
[ENPART_NAME] [char] (30) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
[ENPART_SPEC] [char] (20) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
[ENPART_ASEM] [char] (1) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
[ENPART_DEACTIVE] [char] (1) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL
,
[ENPART_MODEL] [char] (20) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
[ENPART_RETURN] [char] (1) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
[STSHP_COD] [char] (2) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
[STSTCK_COD] [char] (1) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
[ENPART_PNAME] [char] (30) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
[STTPRD_COD] [char] (2) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
[ENPART_NCOD] [char] (8) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
[ENPART_MAP] [char] (25) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
[ENPART_TEC] [char] (30) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
[ENPART_KIND] [char] (1) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
[ENPART_VOL] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
[ENPART_DIA] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
[ENPART_HEIGHT] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
[ENPART_WIDTH] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
[ENPART_LENGTH] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
[ENPART_DENS] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
[ENPART_SPMASS] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
[ENPART_VISCO] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
[ENPART_FLAM] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
[ENPART_PH] [char] (1) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
[ENPART_HARD] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
[ENPART_TENSION] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL
,
[ENPART_JERK] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
[ENPART_STROKE] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
[ENPART_INTORSION] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS
NULL ,
[ENPART_BOND] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
[ENPART_VOLT] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
[ENPART_POWER] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
[ENPART_AMPERE] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
[ENPART_PHASE] [char] (1) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
[ENPART_CYCLE] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
[ENPART_STRING] [char] (2) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
[ENPART_IDCODE] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
[ENPART_BUSHDEG] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL
,
[ENPART_FREQ] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
[ENPART_THECONS] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL
,
[ENPART_STCONS] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
[ENPART_AVCONS] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
[ENPART_PKCOD] [char] (1) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
[ENPART_PKAMNT] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
[ENPART_PKDIM] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
[ENPART_PKMASS] [varchar] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS
NULL ,
[ENPART_ENDESC] [varchar] (2000) COLLATE SQL_Latin1_General_CP1256_CI_AS
NULL ,
[ENPART_TEMP] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
[ENPART_DAMP] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
[ENPART_LIGHT] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
[ENPART_ARRANG] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
[ENPART_CONSTIME] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL
,
[ENPART_CONSERV] [varchar] (2000) COLLATE SQL_Latin1_General_CP1256_CI_AS
NULL ,
[ENPART_DIMEXAM] [varchar] (2000) COLLATE SQL_Latin1_General_CP1256_CI_AS
NULL ,
[ENPART_OUTEXAM] [varchar] (2000) COLLATE SQL_Latin1_General_CP1256_CI_AS
NULL ,
[ENPART_ELECEXAM] [varchar] (2000) COLLATE SQL_Latin1_General_CP1256_CI_AS
NULL ,
[ENPART_MECEXAM] [varchar] (2000) COLLATE SQL_Latin1_General_CP1256_CI_AS
NULL ,
[ENPART_PHYSEXAM] [varchar] (2000) COLLATE SQL_Latin1_General_CP1256_CI_AS
NULL ,
[ENPART_CHEMEXAM] [varchar] (2000) COLLATE SQL_Latin1_General_CP1256_CI_AS
NULL ,
[ENPART_THEMEXAM] [varchar] (2000) COLLATE SQL_Latin1_General_CP1256_CI_AS
NULL ,
[ENPART_ASEMEXAM] [varchar] (2000) COLLATE SQL_Latin1_General_CP1256_CI_AS
NULL ,
[ENPART_USAGEXAM] [varchar] (2000) COLLATE SQL_Latin1_General_CP1256_CI_AS
NULL ,
[ENPART_FINEXAM] [varchar] (2000) COLLATE SQL_Latin1_General_CP1256_CI_AS
NULL ,
[ENPART_SAMPLING] [varchar] (300) COLLATE SQL_Latin1_General_CP1256_CI_AS
NULL ,
[ENPART_LOC] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
[ENPART_MINSTOCK] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL
,
[ENPART_MAXSTOCK] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL
,
[ENPART_ORDERLIM] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL
,
[ENPART_ORDERAMNT] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS
NULL ,
[ENPART_PROGTIM] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL
,
[ENPART_PLDESC] [varchar] (1500) COLLATE SQL_Latin1_General_CP1256_CI_AS
NULL ,
[ENPART_SOURCE] [char] (1) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
[ENPART_SUPLOC] [char] (1) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
[ENPART_MINREQ] [char] (15) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
[ENPART_REQTIME] [char] (15) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL
,
[ENPART_SUGPK] [char] (100) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
[ENPART_PROVTYP] [char] (1) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
[ENPART_SUDESC] [varchar] (1500) COLLATE SQL_Latin1_General_CP1256_CI_AS
NULL ,
[ENPART_MASS] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
CONSTRAINT [PK__ENPARTT] PRIMARY KEY CLUSTERED (
[ENPART_COD]
) ON [PRIMARY] ,
CONSTRAINT [FK_ENPARTT_STSHPT] FOREIGN KEY (
[STSHP_COD]
) REFERENCES [STSHPT] (
[STSHP_COD]
),
CONSTRAINT [FK_ENPARTT_STSTCKT] FOREIGN KEY (
[STSTCK_COD]
) REFERENCES [STSTCKT] (
[STSTCK_COD]
),
CONSTRAINT [FK_ENPARTT_STTPRDT] FOREIGN KEY (
[STTPRD_COD]
) REFERENCES [STTPRDT] (
[STTPRD_COD]
)
) ON [PRIMARY]
GO
---------------------------------
Warning: The table 'ENPARTT' has been created but its maximum row size
(28078) exceeds the maximum number of bytes per row (8060). INSERT or
UPDATE of a row in this table will fail if the resulting row length exceeds
8060 bytes.
--
Thanks for any guide
Using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/