将 varchar 值 ‘日用百货’ 转换为数据类型为 int 的列时发生语法错误。一个头俩大，，，求大神帮忙解决。。。在线等捉鸡的说

qq_33264042 2018-01-11 08:18:12
这个是一个软件来的，原来写的东东直接运行就行了，这把运行之后就出现这个了，不知道是 SQL SERVER 数据库哪里出现问题了还是咋的了。 本来就蒙圈，看着下面这个更蒙圈，啥也没变咋就出了错尼。。。。。。。
[DBConfig]
DB = Provider=SQLOLEDB.1;Password=200006;Persist Security Info=True;User ID=sa;Initial Catalog=zqmis总部2016;Data Source=192.168.1.180
[TPConfig]
TP =1
[CDConfig]
CD =38988d71d64527bb6e4ef98de291876d
[ALARMConfig]
SET1 =33
SET2 =11
SET3 =11
SET4 =11
SET5 =11
[MDConfig]
md1conn = 'SQLOLEDB.1','192.168.1.2';'sa';'200006';'SELECT sptm,tcdj FROM qmis配送原文件.dbo.spdw'
md2conn = 'SQLOLEDB.1','192.168.1.3';'sa';'200006';'SELECT sptm,tcdj FROM qmis水屯.dbo.spdw'
md3conn = 'SQLOLEDB.1','192.168.1.4';'sa';'200006';'SELECT sptm,tcdj FROM qmis高墙王.dbo.spdw'
md4conn = 'SQLOLEDB.1','192.168.1.5';'sa';'200006';'SELECT sptm,tcdj FROM qmis大明湖.dbo.spdw'
md5conn = 'SQLOLEDB.1','192.168.1.6';'sa';'200006';'SELECT sptm,tcdj FROM qmis配送.dbo.spdw'
md6conn = 'SQLOLEDB.1','192.168.1.7';'sa';'200006';'SELECT sptm,tcdj FROM qmis十六里河.dbo.spdw'
md7conn = 'SQLOLEDB.1','192.168.1.9';'sa';'200006';'SELECT sptm,tcdj FROM qmis黄台.dbo.spdw'
md8conn = 'SQLOLEDB.1','192.168.1.2';'sa';'200006';'SELECT sptm,tcdj FROM qmis祝甸.dbo.spdw'
md9conn = 'SQLOLEDB.1','192.168.1.2';'sa';'200006';'SELECT sptm,tcdj FROM qmis祝甸.dbo.spdw'
md10conn = 'SQLOLEDB.1','192.168.1.2';'sa';'200006';'SELECT sptm,tcdj FROM qmis祝甸.dbo.spdw'

md1conn = 'SQLOLEDB.1','192.168.1.2';'sa';'200006';'SELECT sptm,tcdj FROM qmis祝甸.dbo.spdw'
md1conn = 'SQLOLEDB.1','192.168.1.2';'sa';'200006';'SELECT sptm,tcdj FROM qmis祝甸.dbo.spdw'
md1conn = 'SQLOLEDB.1','192.168.1.2';'sa';'200006';'SELECT sptm,tcdj FROM qmis祝甸.dbo.spdw'
md1conn = 'SQLOLEDB.1','192.168.1.2';'sa';'200006';'SELECT sptm,tcdj FROM qmis祝甸.dbo.spdw'
md1conn = 'SQLOLEDB.1','192.168.1.2';'sa';'200006';'SELECT sptm,tcdj FROM qmis祝甸.dbo.spdw'
md1conn = 'SQLOLEDB.1','192.168.1.2';'sa';'200006';'SELECT sptm,tcdj FROM qmis祝甸.dbo.spdw'
md1conn = 'SQLOLEDB.1','192.168.1.2';'sa';'200006';'SELECT sptm,tcdj FROM qmis祝甸.dbo.spdw'
md1conn = 'SQLOLEDB.1','192.168.1.2';'sa';'200006';'SELECT sptm,tcdj FROM qmis祝甸.dbo.spdw'
md1conn = 'SQLOLEDB.1','192.168.1.2';'sa';'200006';'SELECT sptm,tcdj FROM qmis祝甸.dbo.spdw'
md1conn = 'SQLOLEDB.1','192.168.1.2';'sa';'200006';'SELECT sptm,tcdj FROM qmis祝甸.dbo.spdw'

md1conn = 'SQLOLEDB.1','192.168.1.2';'sa';'200006';'SELECT sptm,tcdj FROM qmis祝甸.dbo.spdw'
md1conn = 'SQLOLEDB.1','192.168.1.2';'sa';'200006';'SELECT sptm,tcdj FROM qmis祝甸.dbo.spdw'
md1conn = 'SQLOLEDB.1','192.168.1.2';'sa';'200006';'SELECT sptm,tcdj FROM qmis祝甸.dbo.spdw'
md1conn = 'SQLOLEDB.1','192.168.1.2';'sa';'200006';'SELECT sptm,tcdj FROM qmis祝甸.dbo.spdw'
md1conn = 'SQLOLEDB.1','192.168.1.2';'sa';'200006';'SELECT sptm,tcdj FROM qmis祝甸.dbo.spdw'
md1conn = 'SQLOLEDB.1','192.168.1.2';'sa';'200006';'SELECT sptm,tcdj FROM qmis祝甸.dbo.spdw'
md1conn = 'SQLOLEDB.1','192.168.1.2';'sa';'200006';'SELECT sptm,tcdj FROM qmis祝甸.dbo.spdw'
md1conn = 'SQLOLEDB.1','192.168.1.2';'sa';'200006';'SELECT sptm,tcdj FROM qmis祝甸.dbo.spdw'
md1conn = 'SQLOLEDB.1','192.168.1.2';'sa';'200006';'SELECT sptm,tcdj FROM qmis祝甸.dbo.spdw'
md1conn = 'SQLOLEDB.1','192.168.1.2';'sa';'200006';'SELECT sptm,tcdj FROM qmis祝甸.dbo.spdw'

md1conn = 'SQLOLEDB.1','192.168.1.2';'sa';'200006';'SELECT sptm,tcdj FROM qmis祝甸.dbo.spdw'
md1conn = 'SQLOLEDB.1','192.168.1.2';'sa';'200006';'SELECT sptm,tcdj FROM qmis祝甸.dbo.spdw'
md1conn = 'SQLOLEDB.1','192.168.1.2';'sa';'200006';'SELECT sptm,tcdj FROM qmis祝甸.dbo.spdw'
md1conn = 'SQLOLEDB.1','192.168.1.2';'sa';'200006';'SELECT sptm,tcdj FROM qmis祝甸.dbo.spdw'
md1conn = 'SQLOLEDB.1','192.168.1.2';'sa';'200006';'SELECT sptm,tcdj FROM qmis祝甸.dbo.spdw'
md1conn = 'SQLOLEDB.1','192.168.1.2';'sa';'200006';'SELECT sptm,tcdj FROM qmis祝甸.dbo.spdw'
md1conn = 'SQLOLEDB.1','192.168.1.2';'sa';'200006';'SELECT sptm,tcdj FROM qmis祝甸.dbo.spdw'
md1conn = 'SQLOLEDB.1','192.168.1.2';'sa';'200006';'SELECT sptm,tcdj FROM qmis祝甸.dbo.spdw'
md1conn = 'SQLOLEDB.1','192.168.1.2';'sa';'200006';'SELECT sptm,tcdj FROM qmis祝甸.dbo.spdw'
md1conn = 'SQLOLEDB.1','192.168.1.2';'sa';'200006';'SELECT sptm,tcdj FROM qmis祝甸.dbo.spdw'

md1conn = 'SQLOLEDB.1','192.168.1.2';'sa';'200006';'SELECT sptm,tcdj FROM qmis祝甸.dbo.spdw'
md1conn = 'SQLOLEDB.1','192.168.1.2';'sa';'200006';'SELECT sptm,tcdj FROM qmis祝甸.dbo.spdw'
md1conn = 'SQLOLEDB.1','192.168.1.2';'sa';'200006';'SELECT sptm,tcdj FROM qmis祝甸.dbo.spdw'
md1conn = 'SQLOLEDB.1','192.168.1.2';'sa';'200006';'SELECT sptm,tcdj FROM qmis祝甸.dbo.spdw'
md1conn = 'SQLOLEDB.1','192.168.1.2';'sa';'200006';'SELECT sptm,tcdj FROM qmis祝甸.dbo.spdw'
md1conn = 'SQLOLEDB.1','192.168.1.2';'sa';'200006';'SELECT sptm,tcdj FROM qmis祝甸.dbo.spdw'
md1conn = 'SQLOLEDB.1','192.168.1.2';'sa';'200006';'SELECT sptm,tcdj FROM qmis祝甸.dbo.spdw'
md1conn = 'SQLOLEDB.1','192.168.1.2';'sa';'200006';'SELECT sptm,tcdj FROM qmis祝甸.dbo.spdw'
md1conn = 'SQLOLEDB.1','192.168.1.2';'sa';'200006';'SELECT sptm,tcdj FROM qmis祝甸.dbo.spdw'
md1conn = 'SQLOLEDB.1','192.168.1.2';'sa';'200006';'SELECT sptm,tcdj FROM qmis祝甸.dbo.spdw'

md1conn = 'SQLOLEDB.1','192.168.1.2';'sa';'200006';'SELECT sptm,tcdj FROM qmis祝甸.dbo.spdw'
md1conn = 'SQLOLEDB.1','192.168.1.2';'sa';'200006';'SELECT sptm,tcdj FROM qmis祝甸.dbo.spdw'
md1conn = 'SQLOLEDB.1','192.168.1.2';'sa';'200006';'SELECT sptm,tcdj FROM qmis祝甸.dbo.spdw'
md1conn = 'SQLOLEDB.1','192.168.1.2';'sa';'200006';'SELECT sptm,tcdj FROM qmis祝甸.dbo.spdw'
md1conn = 'SQLOLEDB.1','192.168.1.2';'sa';'200006';'SELECT sptm,tcdj FROM qmis祝甸.dbo.spdw'
md1conn = 'SQLOLEDB.1','192.168.1.2';'sa';'200006';'SELECT sptm,tcdj FROM qmis祝甸.dbo.spdw'
md1conn = 'SQLOLEDB.1','192.168.1.2';'sa';'200006';'SELECT sptm,tcdj FROM qmis祝甸.dbo.spdw'
md1conn = 'SQLOLEDB.1','192.168.1.2';'sa';'200006';'SELECT sptm,tcdj FROM qmis祝甸.dbo.spdw'
md1conn = 'SQLOLEDB.1','192.168.1.2';'sa';'200006';'SELECT sptm,tcdj FROM qmis祝甸.dbo.spdw'
md1conn = 'SQLOLEDB.1','192.168.1.2';'sa';'200006';'SELECT sptm,tcdj FROM qmis祝甸.dbo.spdw'

md1conn = 'SQLOLEDB.1','192.168.1.2';'sa';'200006';'SELECT sptm,tcdj FROM qmis祝甸.dbo.spdw'
md1conn = 'SQLOLEDB.1','192.168.1.2';'sa';'200006';'SELECT sptm,tcdj FROM qmis祝甸.dbo.spdw'
md1conn = 'SQLOLEDB.1','192.168.1.2';'sa';'200006';'SELECT sptm,tcdj FROM qmis祝甸.dbo.spdw'
md1conn = 'SQLOLEDB.1','192.168.1.2';'sa';'200006';'SELECT sptm,tcdj FROM qmis祝甸.dbo.spdw'
md1conn = 'SQLOLEDB.1','192.168.1.2';'sa';'200006';'SELECT sptm,tcdj FROM qmis祝甸.dbo.spdw'
md1conn = 'SQLOLEDB.1','192.168.1.2';'sa';'200006';'SELECT sptm,tcdj FROM qmis祝甸.dbo.spdw'
md1conn = 'SQLOLEDB.1','192.168.1.2';'sa';'200006';'SELECT sptm,tcdj FROM qmis祝甸.dbo.spdw'
md1conn = 'SQLOLEDB.1','192.168.1.2';'sa';'200006';'SELECT sptm,tcdj FROM qmis祝甸.dbo.spdw'
md1conn = 'SQLOLEDB.1','192.168.1.2';'sa';'200006';'SELECT sptm,tcdj FROM qmis祝甸.dbo.spdw'
md1conn = 'SQLOLEDB.1','192.168.1.2';'sa';'200006';'SELECT sptm,tcdj FROM qmis祝甸.dbo.spdw'

md1conn = 'SQLOLEDB.1','192.168.1.2';'sa';'200006';'SELECT sptm,tcdj FROM qmis祝甸.dbo.spdw'
md1conn = 'SQLOLEDB.1','192.168.1.2';'sa';'200006';'SELECT sptm,tcdj FROM qmis祝甸.dbo.spdw'
md1conn = 'SQLOLEDB.1','192.168.1.2';'sa';'200006';'SELECT sptm,tcdj FROM qmis祝甸.dbo.spdw'
md1conn = 'SQLOLEDB.1','192.168.1.2';'sa';'200006';'SELECT sptm,tcdj FROM qmis祝甸.dbo.spdw'
md1conn = 'SQLOLEDB.1','192.168.1.2';'sa';'200006';'SELECT sptm,tcdj FROM qmis祝甸.dbo.spdw'
md1conn = 'SQLOLEDB.1','192.168.1.2';'sa';'200006';'SELECT sptm,tcdj FROM qmis祝甸.dbo.spdw'
md1conn = 'SQLOLEDB.1','192.168.1.2';'sa';'200006';'SELECT sptm,tcdj FROM qmis祝甸.dbo.spdw'
md1conn = 'SQLOLEDB.1','192.168.1.2';'sa';'200006';'SELECT sptm,tcdj FROM qmis祝甸.dbo.spdw'
md1conn = 'SQLOLEDB.1','192.168.1.2';'sa';'200006';'SELECT sptm,tcdj FROM qmis祝甸.dbo.spdw'
md1conn = 'SQLOLEDB.1','192.168.1.2';'sa';'200006';'SELECT sptm,tcdj FROM qmis祝甸.dbo.spdw'

md1conn = 'SQLOLEDB.1','192.168.1.2';'sa';'200006';'SELECT sptm,tcdj FROM qmis祝甸.dbo.spdw'
md1conn = 'SQLOLEDB.1','192.168.1.2';'sa';'200006';'SELECT sptm,tcdj FROM qmis祝甸.dbo.spdw'
md1conn = 'SQLOLEDB.1','192.168.1.2';'sa';'200006';'SELECT sptm,tcdj FROM qmis祝甸.dbo.spdw'
md1conn = 'SQLOLEDB.1','192.168.1.2';'sa';'200006';'SELECT sptm,tcdj FROM qmis祝甸.dbo.spdw'
md1conn = 'SQLOLEDB.1','192.168.1.2';'sa';'200006';'SELECT sptm,tcdj FROM qmis祝甸.dbo.spdw'
md1conn = 'SQLOLEDB.1','192.168.1.2';'sa';'200006';'SELECT sptm,tcdj FROM qmis祝甸.dbo.spdw'
md1conn = 'SQLOLEDB.1','192.168.1.2';'sa';'200006';'SELECT sptm,tcdj FROM qmis祝甸.dbo.spdw'
md1conn = 'SQLOLEDB.1','192.168.1.2';'sa';'200006';'SELECT sptm,tcdj FROM qmis祝甸.dbo.spdw'
md1conn = 'SQLOLEDB.1','192.168.1.2';'sa';'200006';'SELECT sptm,tcdj FROM qmis祝甸.dbo.spdw'
md1conn = 'SQLOLEDB.1','192.168.1.2';'sa';'200006';'SELECT sptm,tcdj FROM qmis祝甸.dbo.spdw'
...全文
436 5 打赏 收藏 转发到动态 举报
写回复
用AI写文章
5 条回复
切换为时间正序
请发表友善的回复…
发表回复
OwenZeng_DBA 2018-01-11
  • 打赏
  • 举报
 回复
不是在线等，很捉急吗，，楼主人呢
Ginnnnnnnn 2018-01-11
  • 打赏
  • 举报
 回复
通常就是拼接字符串的时候有拼接了一个数字类型的列，然后就报错了，重点检查一下数值型的列就好了
二月十六 2018-01-11
  • 打赏
  • 举报
 回复
这个提示倒是明显，但是在楼主贴的信息里找到相关的东西。。
OwenZeng_DBA 2018-01-11
  • 打赏
  • 举报
 回复
一步一步缩小问题的范围吧，你这个就是类型转换的问题。最关键是找到出错的SQL语句
吉普赛的歌 2018-01-11
  • 打赏
  • 举报
 回复
用 sqlprofiler 跟踪一下出错的SQL ， 再贴出来
解决SQL将varchar值转换为数据类型为int的列时发生语法错误
今天遇到一个将**varchar**转化成**int**的错误 尝试了用convert(int,@score)发现系统依然报一样的错误，又尝试使用cast（@score as int）发现还是报一样的错误。 由于score中存放的是varchar 类型的，所以尝试着将@score先转化成float类型，在转化成int类型，结果错误解决了。虽然问题解决了，但是还不是很明白为什么需要先将其转化成float类型在转化成int类型。 有没有大神告知原因，不胜感激。 select @sjmczxdw = conve
pgsql 比较数字字符串_postgreSQL数据类型转换字符串和数值
1、将数值转成字符串类型方法1：调用to_char(int, text)函数，int为要转换值，text为数值格式化模式，其中模式描述为：模式 描述9 带有指定数值位数的值0 带前导零的值.(句点) 小数点,(逗号) 分组(千)分隔符PR 尖括号内负值S 带符号的数值L 货币符号D 小数点G 分组分隔符MI 在指明的位置的负号(如果数字 < 0)PL 在指明的位置的正号(如果数字 > ...
MySQL数据库（表的相关操作-创建查看删除以及表的主键/唯一/非空/默认/外键约束）以及常见报错分析--刘港辉学编程
在阅读本章之前需要学习一些Navicat基本的操作和数据库相关概念 数据库基本操作 数据库数据类型 表的相关操作 一.创建表（create） 结构：create table xxx(字段名1 数据类型1，字段名2 数据类型2); create table是创建表的关键字 id name sex 等等都是字段名，是形容描述数据的 int varchar(10) float 等等都是数据类型，用来表示数据的类型 -- 创建一个个人信息表，有id，有name create table lgh( id in.
Mysql --常见数据类型
说到数据类型往往牵扯着数据类型的转换，如何选择合适的数据类型等 部分内容来源CSDN等 如未注明 请及时联系我 以下内容是我个人对于mysql的学习和笔记 如有错误之处， 还请大神及时纠正。 说到数据类型 我们常常是在如何选择合适的数据类型上犯愁？ 在解决上面的问题之前，我们必须清楚的知道数据类型有哪些？它们的区别是什么？ 常见的数据类型主要分为以下几类： 一. 数值型 整型 INT(N...
数据库的创建表时，字段的数据类型和约束条件
文章目录数值类型：整数类型：浮点型：日期类型：字符串类型：枚举类型与集合类型： 数值类型： 整数类型： tinyint 默认有符号，[unsigned]代表无符号，超出范围显示最大范围。 语法： tinyint[(m)] [unsigned] [zerofill] int类型无符号的存储宽度4个字节， 创建表整形类型不指定宽度。指定宽度对存储宽度没用，只是更改显示宽度。显示宽度是指...
疑难问题

22,209

社区成员

121,731

社区内容

发帖
与我相关
我的任务
社区描述
MS-SQL Server 疑难问题
社区管理员
  • 疑难问题社区
  • 尘觉
加入社区
  • 近7日
  • 近30日
  • 至今

加载中

查看更多榜单
社区公告
暂无公告

试试用AI创作助手写篇文章吧

+ 用AI写文章