SQL出现Conversion failed nvarchar int
SQL出现Conversion failed nvarchar int
繁华是客
发布于 2023-03-03 20:17:10
发布于 2023-03-03 20:17:10
序
Conversion failed when converting the nvarchar value ‘abcdef’ to data type int.
表中其中值存在abc和123
这是因为表中值有abc也有123导致无法转换。
例子:
| HEADER1 | Column | HEADER3 | HEADER4 | | content | abc | content | content | | content | bbc | content | content | | content | 123 | content | content | | content | 345 | content | content |
解决办法
原文：
SELECT pbi.[PID]
,pbi.[SN]
,pbi.[FN]
,pbi.[G]
,pbi.[F]
,pbi.[YG]
,pbi.[H]
,pbi.[PS]
,pbi.[AN]
,um.PUID, um.UN,ulh.IPA,ulh.LDate
FROM [TestingTable].[dbo].[View_ContactDetail] as pbi
Left join UserMaster um on pbi.AN=um.PUID
LEFT JOIN [UserLoginHistory] ulh on um.PUID = ulh.PUID AND ulh.LoginNumber = 1
WHERE um.PUID is not null添加排除abc字母
and um.PortalUserID not like '%[^0-9]%'修改后
SELECT pbi.[PID]
,pbi.[SN]
,pbi.[FN]
,pbi.[G]
,pbi.[F]
,pbi.[YG]
,pbi.[H]
,pbi.[PS]
,pbi.[AN]
,um.PUID, um.UN,ulh.IPA,ulh.LDate
FROM [TestingTable].[dbo].[View_ContactDetail] as pbi
Left join UserMaster um on pbi.AN=um.PUID and um.PortalUserID not like '%[^0-9]%'
LEFT JOIN [UserLoginHistory] ulh on um.PUID = ulh.PUID AND ulh.LoginNumber = 1
WHERE um.PUID is not null本文参与 腾讯云自媒体同步曝光计划，分享自作者个人站点/博客。
原始发表：2019-12-02
，如有侵权请联系 cloudcommunity@tencent.com 删除
评论
登录后参与评论
推荐阅读
目录