人大金仓sqlserver 模式下 报value too long for type varchar(30)” 返回
Miracle 发布于1个月前
金仓下面生成的sql SELECT "Depart_Id","DepartName","OrgType","ModifyID","Modifier","ModifyDate","CreateDate","CreateID","Creator","ParentId","Paths","Levels","Enabled","SortId","DepartManager","DepartDeputy","Leader","Adminers","OaAuditor","IsGroup","Finance","Cashier","ShortName","IsWithCal" FROM "Sys_Depart" WHERE (@MethodConst0 like '%'+ CAST("Depart_Id" AS VARCHAR)+'%')
换成sqlserver 生成的sql SELECT "Depart_Id","DepartName","OrgType","ModifyID","Modifier","ModifyDate","CreateDate","CreateID","Creator","ParentId","Paths","Levels","Enabled","SortId","DepartManager","DepartDeputy","Leader","Adminers","OaAuditor","IsGroup","Finance","Cashier","ShortName","IsWithCal" FROM "Sys_Depart" WHERE (@MethodConst0 like '%'+ CAST("Depart_Id" AS NVARCHAR(max))+'%')
金仓模式下 转换没指定位数，会报错
热忱回答（2）
-
fate sta VIP0
1个月前预览版本已发布
0 回复 -
Miracle VIP0
1个月前
@fate sta：可以了感谢
0 回复