在将varchar值'12B91973-364D-9FC7-680470D88874'变换为数据类型int时失败
在将varchar值'12B91973-364D-9FC7-680470D88874'转换为数据类型int时失败
麻烦给位高手帮忙看看是哪儿出问题了~~急啊~~谢谢了
------解决方案--------------------
找出这个值对应的列'12B91973-364D-9FC7-680470D88874',应该这列是int类型,而你直接插入,导致无法从字符串转换成数值型导致报错。
------解决方案--------------------
- SQL code
SELECT A.username, A.fullname, A.password, A.userid, A.email, A.telephone, A.mobilephone, A.mphone, A.fax, A.worked_time, A.fee_center, A.reg_num, A.titleofpost, A.isenable, A.isadmin, A.memo, A.mailsize, A.conf_password, A.guid, A.img, CASE ison WHEN 1 THEN '在岗' ELSE '离岗' END AS isonmc, A.ison, A.orderid, dbo.EF_GETMNG(A.username) AS 主管, B.org FROM dbo.sys_user AS A LEFT OUTER JOIN dbo.sys_orgmenber AS B ON A.username = B.member UNION SELECT bm, cjr, cjrbm, cjrgw, cz, dw, fjh, qq, qyyx, sjdh, txdz, wb, wbyx, xm, yb, yddh, zjh, zy, sslb, gstxl, wldwtxl, guid, ' ' AS Expr1, ' ' AS Expr2, ' ' AS Expr3 FROM dbo.txl
麻烦给位高手帮忙看看是哪儿出问题了~~急啊~~谢谢了
------解决方案--------------------
找出这个值对应的列'12B91973-364D-9FC7-680470D88874',应该这列是int类型,而你直接插入,导致无法从字符串转换成数值型导致报错。
------解决方案--------------------