如何解决将varchar值'YES'转换为数据类型int时转换失败。 [英] how to solve Conversion failed when converting the varchar value 'YES' to data type int.

问题描述

Hello Team，



我有CustomerLoanData表

在该表中，ColumnName addrverify是varchar .it必须是varchar



现在我的问题是当我触发选择查询时如下。我收到了错误。所以我应该如何解决这个问题。

 选择 ID，FULLADDRESS，CUSTOMERADDR1，CUSTOMERADDR2，LANDMARK，CITY，STATE，PINCODE 来自 customerloandata 
  （ nolock ）其中 CITY = ' ' 或 STATE = ' ' 或 PINCODE = ' ' 和 isnull（addrverify， 0 ）=  0  

错误：将varchar值'YES'转换为数据类型int时转换失败。



谢谢

Harshal

解决方案

改为这样做

 选择 ID，FULLADDRESS，CUSTOMERADDR1，CUSTOMERADDR2，LANDMARK，CITY，STATE，PINCODE 来自 customerloandata 
  with （ nolock ）其中 CITY = ' ' 或 STATE = ' ' 或 PINCODE = ' ' 和 isnull（addrverify，'  NO'）= '  NO' 

如果addrverify是varchar，则不能用数字替换空值。坚持使用相同的数据类型。

因为你试图

 nvarchar（max） =  int  

试试这个：

 选择 ID，FULLADDRESS，CUSTOMERADDR1，CUSTOMERADDR2，LANDMARK，CITY，STATE，PINCODE 来自 customerloandata 
  with （ nolock ）< span class =code-keyword>其中 CITY = ' ' 或 STATE = ' ' 或 PINCODE = ' ' 和 isnull（addrverify， 0 ）= ' ' 

Hello Team,

I have the CustomerLoanData Table
In that table, ColumnName addrverify is varchar .it has to be varchar

Now my problem is when i am firing the select Query as follow . I am getting the error .So how should i solve this .

select ID,FULLADDRESS,CUSTOMERADDR1,CUSTOMERADDR2,LANDMARK,CITY,STATE, PINCODE from customerloandata
 with (nolock) where CITY =''or STATE ='' or PINCODE = '' and isnull(addrverify,0) = 0

Error : Conversion failed when converting the varchar value 'YES' to data type int.

Thanks
Harshal

解决方案

Do this instead

select ID,FULLADDRESS,CUSTOMERADDR1,CUSTOMERADDR2,LANDMARK,CITY,STATE, PINCODE from customerloandata
 with (nolock) where CITY =''or STATE ='' or PINCODE = '' and isnull(addrverify,'NO') = 'NO'

If addrverify is a varchar, you cannot replace a null value with a number. Stick with the same datatype.

Because you are trying to

nvarchar(max)=int

try with this:

select ID,FULLADDRESS,CUSTOMERADDR1,CUSTOMERADDR2,LANDMARK,CITY,STATE, PINCODE from customerloandata
 with (nolock) where CITY =''or STATE ='' or PINCODE = '' and isnull(addrverify,0) =''

这篇关于如何解决将varchar值'YES'转换为数据类型int时转换失败。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！