生成的sql 某个字段长度超过报错截断二进制 返回
sqlserver 数据库
INSERT [PBOrderRec] ([RowID],[OrderID],[OrderType],[OrderNo],[ProductSize],[OldPrdName],[InputCount],[CCT],[PassRate],[ChipMaterialNo],[ChipMaterialName],[ChipBD],[ChipLD],[ZJMaterialName],[ZJProductSize],[SeqNo1],[SeqNo2],[SeqNo3],[SeqNo4],[SeqNo5],[SeqNo6],[MtrWeight1],[MtrWeight2],[MtrWeight3],[MtrWeight4],[MtrWeight5],[MtrWeight6],[FGBinRatio],[FGWIPQty],[FGSplitQty],[RecordID])
SELECT N'b7e0604e-ce9c-46ad-83c7-5b6818d98258' AS [RowID],N'fc97d4da-51c0-4672-85f0-0578317d886a' AS [OrderID],N'G330' AS [OrderType],N'26070039' AS [OrderNo],N'A4014A-A0FR-D68W90-2CS1' AS [ProductSize],N'A-4014D68W-2C-S1-HR5-DM-HL' AS [OldPrdName],N'1397448' AS [InputCount],N'6000-7000,分成6000-6500K(CS1-A);6500-7000K(CS1-B)' AS [CCT],N'91.33%' AS [PassRate],N'92010140290000H5' AS [ChipMaterialNo],N'三安_S-30KBMUD-I_15*30mil_正装 发光芯片 D4B' AS [ChipMaterialName],N'455-457.5' AS [ChipBD],N'210-230' AS [ChipLD],N'良友_A-4014-DM-Y_SMD TOP 支架' AS [ZJMaterialName],N'144*60*0.62_22*24_铜材(无孔)_黄铜 0.20_镍上银_PPA_112原料 15μ" 方杯 3:7 4.0mm*1.45mm' AS [ZJProductSize],N'RH665-298' AS [SeqNo1],N'SSDR650' AS [SeqNo2],N'SDG525Q' AS [SeqNo3],N'1365DA' AS [SeqNo4],N'1365DB' AS [SeqNo5],NULL AS [SeqNo6],N'0.1250000000' AS [MtrWeight1],N'0.0830000000' AS [MtrWeight2],N'3.6445000000' AS [MtrWeight3],N'1.0350000000' AS [MtrWeight4],N'10.3500000000' AS [MtrWeight5],NULL AS [MtrWeight6],N'108.10%' AS [FGBinRatio],N'-36243' AS [FGWIPQty],N'1510673' AS [FGSplitQty],NULL AS [RecordID]
生成的这段sql,CCT的长度数据库表设置的是varchar(50),然后这个实际长度只有47,没有超过,但是却报错

大佬麻烦帮我看看是什么原因导致的?实际长度没有超过的
热忱回答(3)
-
梦幻★华尔兹 VIP0
2周前补充一句
return await _Client.Insertable(tList.ToList()).ExecuteCommandIdentityIntoEntityAsync();
用的这个批量插入0 回复 -
fate sta VIP0
1周前SQL中带了N。会大一倍。
0 回复 -
fate sta VIP0
1周前数据库调大一部就行了。或者直接用GUID类型
0 回复