頭痛的 String or binary data would be truncated 錯誤

Question

用戶機的Driver為SQL server 3.70,開發用SQL 2000,試過在該用戶機上安裝SQL 2000後,然後反安裝(Driver升級為SQL 2000).再運行,還是同樣的錯誤.用的是同一個數據庫,所以排除column長度而引致錯誤的可能.操作系統均為windows 2000 5.0 SP4原SQL語句如下:(XXXXXXXXXXXXX 地方為原用戶名稱.字符數相同)
INSERT INTO DelReqDtl_drd( drd_cReqID,drd_cDtlID,drd_itID,drd_iLotNo, drd_cStatus,drd_iQty,drd_cUnit,drd_cBaseUnit,drd_iUCRate, drd_lCustCode,drd_cCode,drd_cCur,drd_fProformaValue, drd_iQtyPerCarton,drd_fCartonLength,drd_fCartonWidth,drd_fCartonHeight,  drd_fCartonVolume,drd_fCartonWeight,drd_cRe, drd_iPalletQty,drd_cPalletType, drd_fPalletLength,drd_fPalletWidth,drd_fPalletHeight,drd_fPalletWeight,drd_cPalletRe, drd_cAttachment,drd_cPalletMark,drd_lGoodsCheck,Drd_dETD,Drd_dETA,drd_cAddBy,drd_dAddDate,drd_cLastUpdBy,drd_dLastUpdDate) VALUES( 'DRM0025187', '1',75893, 1, 'PEND',3000, 'COP', 'COP',1, '1', '49019900', 'EURO',0.01,48,36,31,13,0.0145,5.2, N'',0, 'EU',120,80,16,25, N'',N'',N'', '0',CONVERT (datetime,'27/05/2006',103),CONVERT (datetime,'24/06/2006',103), N'XXXXXXXXXXXXX', GETDATE(),N'XXXXXXXXXXXXX', GETDATE())謝謝~

Answer 1

請大家幫我看看,謝謝
column_name, data_type, type_name, precision, length
drd_cReqID 1 char 10 10
drd_cDtlID 5 smallint 5 2
drd_itID 4 int 10 4
drd_cStatus 1 char 4 4
drd_iQty 4 int 10 4
drd_cUnit 1 char 10 10
drd_cBaseUnit 1 char 10 10
drd_iUCRate 5 smallint 5 2
drd_lCustHSCode -7 bit 1 1
drd_cHSCode 1 char 10 10
drd_cCur 1 char 5 5
drd_fProformaValue 3 decimal 18 20
drd_iQtyPerCarton 4 int 10 4
drd_fCartonLength 3 decimal 9 11
drd_fCartonWidth 3 decimal 9 11
drd_fCartonHeight 3 decimal 9 11
drd_fCartonVolume 3 decimal 18 20
drd_fCartonWeight 3 decimal 18 20
drd_fPalletWeight 3 decimal 9 11
drd_cPalletType 1 char 2 2
drd_iPalletQty 5 smallint 5 2
drd_fPalletLength 3 decimal 9 11
drd_fPalletWidth 3 decimal 9 11
drd_fPalletHeight 3 decimal 9 11
drd_cPalletMark -9 nvarchar 100 200
drd_cPalletRe -9 nvarchar 80 160
drd_cAttachment -9 nvarchar 100 200
drd_lGoodsCheck -7 bit 1 1
drd_cRe -9 nvarchar 80 160
drd_dETD 11 datetime 23 16
drd_dETA 11 datetime 23 16
drd_cAddBy -9 nvarchar 20 40
drd_dAddDate 11 datetime 23 16
drd_cLastUpdBy -9 nvarchar 20 40
drd_dLastUpdDate 11 datetime 23 16
drd_iLotNo 5 smallint 5 2