开发者

SQL Server 2005 Converting Data Type Error

开发者 https://www.devze.com 2023-01-11 10:55 出处:网络
I am trying to import varchar data into a varchar data type field but I am getting a conversion error of varchar cannot be converted t开发者_开发技巧o date type bit?How is that when both fields are al

I am trying to import varchar data into a varchar data type field but I am getting a conversion error of varchar cannot be converted t开发者_开发技巧o date type bit? How is that when both fields are already varchar type?

Conversion failed when converting the varchar value 'JOHN KUCHTA' to data type bit.


If you are importing from CSV, for example, you likely have a missing column in one row, or some of the data is incorrect. Is at least one of the fields you are trying to import of type bit?


I looks like you are inserting into the wrong column or you have mismatched the columns

0

精彩评论

暂无评论...
验证码 换一张
取 消