开发者

SQL Server 2005 Converting Data Type Error

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

上一篇:

下一篇:

精彩评论

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

最新问答

问答排行榜