如何在将varchar值'Warangal'转换为数据类型int时，错误消息Msg 245，Level 16，State 1，Line 1转换失败。 [英] how to sole the error Msg 245, Level 16, State 1, Line 1 Conversion failed when converting the varchar value 'Warangal' to data type int.

问题描述

HEllo团队，



我想从数据库中选择空值或空值。

所有列都是varchar。

 选择 ID，FULLADDRESS，CUSTOMERADDR1，CUSTOMERADDR2，LANDMARK，CITY，STATE，PINCODE  from  customerloandata 
  with （ nolock ）其中 isnull（city， 0 ）=  0  或 isnull（状态， 0 ）=  0  或 isnull（PINCODE， 0 ）=  0  

我收到以下错误。



Msg 245,16级，状态1，第1行

将varchar值'Warangal'转换为数据类型int时转换失败。



如何解决？

请帮助



谢谢

Harshal。

解决方案

您正在返回两种不同类型的数据：VARCHAR和INT - 因此SQL尝试提供帮助并自动将VARCHAR解析为你的INT。由于它包含的文本不是;数字，它会失败。

相反，试试这个：

 选择 ID，FULLADDRESS，CUSTOMERADDR1，CUSTOMERADDR2，LANDMARK，CITY，STATE，PINCODE 来自 customerloandata 
  with （ nolock ）其中​​ city  IS   NULL  或 STATE  IS   NULL  或 PINCODE  IS   NULL  

忘记代码块：doh： - OriginalGriff [/ edit ]

HEllo team,

I want to select the null value or empty value from Database.
All columns are varchar.

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

I am getting the following error.

Msg 245, Level 16, State 1, Line 1
Conversion failed when converting the varchar value 'Warangal' to data type int.

How to solve it?
Please help

Thanks
Harshal.

解决方案

You are returning two different types of data: VARCHAR and INT - so SQL tries to be helpful and automatically parse the VARCHAR as an INT for you. Since it contains text that isn;t a number, it fails.
Instead, try this:

select ID,FULLADDRESS,CUSTOMERADDR1,CUSTOMERADDR2,LANDMARK,CITY,STATE, PINCODE from customerloandata
with (nolock) where city IS NULL or STATE IS NULL or PINCODE IS NULL

[edit]Forgot the code block :doh: - OriginalGriff[/edit]

这篇关于如何在将varchar值'Warangal'转换为数据类型int时，错误消息Msg 245，Level 16，State 1，Line 1转换失败。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！