请问高手，SQL语句太长，被截断了！我该怎样办？参与有分！决不食言！

plutu 2003-07-09 09:05:20
我有一条SQL语句是望数据库中插入记录，但是字段有90个，我写的插入语句在执行时说是语句太长，被截断了，当然也没法执行
String or binary data would be truncated.
The statement has been terminated.
我该怎样办？
...全文
674 36 打赏 收藏 转发到动态 举报
写回复
用AI写文章
36 条回复
切换为时间正序
请发表友善的回复…
发表回复
zhoujianfan 2003-07-11
  • 打赏
  • 举报
 回复

"这个错误提示可能并不是说你的SQL语句太长，而可能是在SQL语句里面其中某一个字段的值太长了，你可以将此语句复制到SQL的查询分析器中试试"

同意这个说法
xayzmb 2003-07-11
  • 打赏
  • 举报
 回复
同意是数据库设计问题
就算是SQL通过了
这样的设计也是不合理的
beckham1122 2003-07-11
  • 打赏
  • 举报
 回复
同意

lgxysl 2003-07-11
  • 打赏
  • 举报
 回复
用update能够实现，而且很好，为什么偏要钻牛角尖？
smuzy 2003-07-11
  • 打赏
  • 举报
 回复
傻瓜为什么不用存储过程：
ado的cmd.param..
或者
rs.addnew
rs("field1")=var1
rs("fieldi")=vari
....
rs.update
？
Alicky 2003-07-11
  • 打赏
  • 举报
 回复
好呀。
beibeilong 2003-07-11
  • 打赏
  • 举报
 回复
lai le
plutu 2003-07-11
  • 打赏
  • 举报
 回复
结帖！来者有分！
简易无忌 2003-07-10
  • 打赏
  • 举报
 回复
（不好意思，紧接上页）

s_sql_tj = s_sql_tj + vbCrLf + " 谔谔 = case"

s_sql_tj = s_sql_tj + vbCrLf + " when (select sum(T_jifen.FH6) from T_jifen"

s_sql_tj = s_sql_tj + vbCrLf + " where T_jifen.FH3/100 = 7 and T_jifen.FH1 = T_RENYUAN.FH1 and year(T_jifen.FH5) = " + Now_Year + " and month(T_jifen.FH5) = " + Now_Month + " ) is null then 0"

s_sql_tj = s_sql_tj + vbCrLf + " else (select sum(T_jifen.FH6) from T_jifen"

s_sql_tj = s_sql_tj + vbCrLf + " where T_jifen.FH3/100 = 7 and T_jifen.FH1 = T_RENYUAN.FH1 and year(T_jifen.FH5) = " + Now_Year + " and month(T_jifen.FH5) = " + Now_Month + " )"

s_sql_tj = s_sql_tj + vbCrLf + " end,"

s_sql_tj = s_sql_tj + vbCrLf + " 谔谔谔谔 = case"

s_sql_tj = s_sql_tj + vbCrLf + " when (select sum(T_jifen.FH6) from T_jifen"

s_sql_tj = s_sql_tj + vbCrLf + " where T_jifen.FH3/100 = 1 and T_jifen.FH1 = T_RENYUAN.FH1 and year(T_jifen.FH5) = " + Now_Year + " and month(T_jifen.FH5) = " + Now_Month + " ) is null then 250"

s_sql_tj = s_sql_tj + vbCrLf + " else (select sum(T_jifen.FH6) from T_jifen"

s_sql_tj = s_sql_tj + vbCrLf + " where T_jifen.FH3/100 = 1 and T_jifen.FH1 = T_RENYUAN.FH1 and year(T_jifen.FH5) = " + Now_Year + " and month(T_jifen.FH5) = " + Now_Month + " ) + 250"

s_sql_tj = s_sql_tj + vbCrLf + " end +"

s_sql_tj = s_sql_tj + vbCrLf + " case"

s_sql_tj = s_sql_tj + vbCrLf + " when (select sum(T_jifen.FH6) from T_jifen"

s_sql_tj = s_sql_tj + vbCrLf + " where T_jifen.FH3/100 = 2 and T_jifen.FH1 = T_RENYUAN.FH1 and year(T_jifen.FH5) = " + Now_Year + " and month(T_jifen.FH5) = " + Now_Month + " ) is null then 250"

s_sql_tj = s_sql_tj + vbCrLf + " else (select sum(T_jifen.FH6) from T_jifen"

s_sql_tj = s_sql_tj + vbCrLf + " where T_jifen.FH3/100 = 2 and T_jifen.FH1 = T_RENYUAN.FH1 and year(T_jifen.FH5) = " + Now_Year + " and month(T_jifen.FH5) = " + Now_Month + " ) + 250"

s_sql_tj = s_sql_tj + vbCrLf + " end +"

s_sql_tj = s_sql_tj + vbCrLf + " case"

s_sql_tj = s_sql_tj + vbCrLf + " when (select sum(T_jifen.FH6) from T_jifen"

s_sql_tj = s_sql_tj + vbCrLf + " where T_jifen.FH3/100 = 3 and T_jifen.FH1 = T_RENYUAN.FH1 and year(T_jifen.FH5) = " + Now_Year + " and month(T_jifen.FH5) = " + Now_Month + " ) is null then 200"

s_sql_tj = s_sql_tj + vbCrLf + " else (select sum(T_jifen.FH6) from T_jifen"

s_sql_tj = s_sql_tj + vbCrLf + " where T_jifen.FH3/100 = 3 and T_jifen.FH1 = T_RENYUAN.FH1 and year(T_jifen.FH5) = " + Now_Year + " and month(T_jifen.fh5) = " + Now_Month + " ) + 200"

s_sql_tj = s_sql_tj + vbCrLf + " end +"

s_sql_tj = s_sql_tj + vbCrLf + " case"

s_sql_tj = s_sql_tj + vbCrLf + " when (select sum(T_jifen.FH6) from T_jifen"

s_sql_tj = s_sql_tj + vbCrLf + " where T_jifen.FH3/100 = 4 and T_jifen.FH1 = T_RENYUAN.FH1 and year(T_jifen.FH5) = " + Now_Year + " and month(T_jifen.FH5) = " + Now_Month + " ) is null then 150"

s_sql_tj = s_sql_tj + vbCrLf + " else (select sum(T_jifen.FH6) from T_jifen"

s_sql_tj = s_sql_tj + vbCrLf + " where T_jifen.fh3/100 = 4 and T_jifen.FH1 = T_RENYUAN.FH1 and year(T_jifen.FH5) = " + Now_Year + " and month(T_jifen.FH5) = " + Now_Month + " ) + 150"

s_sql_tj = s_sql_tj + vbCrLf + " end +"

s_sql_tj = s_sql_tj + vbCrLf + " case"

s_sql_tj = s_sql_tj + vbCrLf + " when (select sum(T_jifen.FH6) from T_jifen"

s_sql_tj = s_sql_tj + vbCrLf + " where T_jifen.FH3/100 = 5 and T_jifen.FH1 = T_RENYUAN.FH1 and year(T_jifen.FH5) = " + Now_Year + " and month(T_jifen.FH5) = " + Now_Month + " ) is null then 150"

s_sql_tj = s_sql_tj + vbCrLf + " else (select sum(T_jifen.FH6) from T_jifen"

s_sql_tj = s_sql_tj + vbCrLf + " where T_jifen.fh3/100 = 5 and T_jifen.FH1 = T_RENYUAN.fh1 and year(T_jifen.fh5) = " + Now_Year + " and month(T_jifen.fh5) = " + Now_Month + " ) + 150"

s_sql_tj = s_sql_tj + vbCrLf + " end +"

s_sql_tj = s_sql_tj + vbCrLf + " case"

s_sql_tj = s_sql_tj + vbCrLf + " when (select sum(T_jifen.FH6) from T_jifen"

s_sql_tj = s_sql_tj + vbCrLf + " where T_jifen.FH3/100 = 6 and T_jifen.FH1 = T_RENYUAN.FH1 and year(T_jifen.FH5) = " + Now_Year + " and month(T_jifen.FH5) = " + Now_Month + " ) is null then 0"

s_sql_tj = s_sql_tj + vbCrLf + " else (select sum(T_jifen.FH6) from T_jifen"

s_sql_tj = s_sql_tj + vbCrLf + " where T_jifen.FH3/100 = 6 and T_jifen.FH1 = T_RENYUAN.FH1 and year(T_jifen.FH5) = " + Now_Year + " and month(T_jifen.FH5) = " + Now_Month + " )"

s_sql_tj = s_sql_tj + vbCrLf + " end +"

s_sql_tj = s_sql_tj + vbCrLf + " case"

s_sql_tj = s_sql_tj + vbCrLf + " when (select sum(T_jifen.FH6) from T_jifen"

s_sql_tj = s_sql_tj + vbCrLf + " where T_jifen.FH3/100 = 7 and T_jifen.FH1 = T_RENYUAN.FH1 and year(T_jifen.FH5) = " + Now_Year + " and month(T_jifen.FH5) = " + Now_Month + " ) is null then 0"

s_sql_tj = s_sql_tj + vbCrLf + " else (select sum(T_jifen.FH6) from T_jifen"

s_sql_tj = s_sql_tj + vbCrLf + " where T_jifen.FH3/100 = 7 and T_jifen.FH1 = T_RENYUAN.FH1 and year(T_jifen.FH5) = " + Now_Year + " and month(T_jifen.FH5) = " + Now_Month + " )"

s_sql_tj = s_sql_tj + vbCrLf + " End"

s_sql_tj = s_sql_tj + vbCrLf + " +"

s_sql_tj = s_sql_tj + vbCrLf + S_SQL_JZ
简易无忌 2003-07-10
  • 打赏
  • 举报
 回复
下面是我运行得很正常的语句，我真不知道比你的短多少？（哈哈！内容太长）
s_sql_tj = ""

s_sql_tj = " delete T_jifen_tj where 谔谔 = '" + Now_Year + "-" + Now_Month + "'" + vbCrLf


s_sql_tj = s_sql_tj + " Insert T_jifen_TJ"

s_sql_tj = s_sql_tj + vbCrLf + " select Bumen.FH1 as 谔谔,T_RENYUAN.FH1 as 谔谔,'" + Now_Year + "-" + Now_Month + "' as 谔谔,"

s_sql_tj = s_sql_tj + vbCrLf + " 谔谔 = case"

s_sql_tj = s_sql_tj + vbCrLf + " when (select sum(T_jifen.FH6) from T_jifen"

s_sql_tj = s_sql_tj + vbCrLf + " where T_jifen.FH3/100 = 1 and T_jifen.FH1 = T_RENYUAN.FH1 and year(T_jifen.FH5) = " + Now_Year + " and month(T_jifen.FH5) = " + Now_Month + " ) is null then 250"

s_sql_tj = s_sql_tj + vbCrLf + " else (select sum(T_jifen.FH6) from T_jifen"

s_sql_tj = s_sql_tj + vbCrLf + " where T_jifen.FH3/100 = 1 and T_jifen.FH1 = T_RENYUAN.FH1 and year(T_jifen.FH5) = " + Now_Year + " and month(T_jifen.FH5) = " + Now_Month + " ) + 250"

s_sql_tj = s_sql_tj + vbCrLf + " end,"

s_sql_tj = s_sql_tj + vbCrLf + " 谔谔 = case"

s_sql_tj = s_sql_tj + vbCrLf + " when (select sum(T_jifen.FH6) from T_jifen"

s_sql_tj = s_sql_tj + vbCrLf + " where T_jifen.FH3/100 = 2 and T_jifen.FH1 = T_RENYUAN.FH1 and year(T_jifen.FH5) = " + Now_Year + " and month(T_jifen.FH5) = " + Now_Month + " ) is null then 250"

s_sql_tj = s_sql_tj + vbCrLf + " else (select sum(T_jifen.FH6) from T_jifen"

s_sql_tj = s_sql_tj + vbCrLf + " where T_jifen.FH3/100 = 2 and T_jifen.FH1 = T_RENYUAN.FH1 and year(T_jifen.FH5) = " + Now_Year + " and month(T_jifen.FH5) = " + Now_Month + " ) + 250"

s_sql_tj = s_sql_tj + vbCrLf + " end,"

s_sql_tj = s_sql_tj + vbCrLf + " 谔谔 = case"

s_sql_tj = s_sql_tj + vbCrLf + " when (select sum(T_jifen.FH6) from T_jifen"

s_sql_tj = s_sql_tj + vbCrLf + " where T_jifen.FH3/100 = 3 and T_jifen.FH1 = T_RENYUAN.FH1 and year(T_jifen.FH5) = " + Now_Year + " and month(T_jifen.FH5) = " + Now_Month + " ) is null then 200"

s_sql_tj = s_sql_tj + vbCrLf + " else (select sum(T_jifen.FH6) from T_jifen"

s_sql_tj = s_sql_tj + vbCrLf + " where T_jifen.FH3/100 = 3 and T_jifen.FH1 = T_RENYUAN.FH1 and year(T_jifen.FH5) = " + Now_Year + " and month(T_jifen.FH5) = " + Now_Month + " ) + 200"

s_sql_tj = s_sql_tj + vbCrLf + " end,"

s_sql_tj = s_sql_tj + vbCrLf + " 谔谔 = case"

s_sql_tj = s_sql_tj + vbCrLf + " when (select sum(T_jifen.FH6) from T_jifen"

s_sql_tj = s_sql_tj + vbCrLf + " where T_jifen.FH3/100 = 4 and T_jifen.FH1 = T_RENYUAN.FH1 and year(T_jifen.FH5) = " + Now_Year + " and month(T_jifen.FH5) = " + Now_Month + " ) is null then 150"

s_sql_tj = s_sql_tj + vbCrLf + " else (select sum(T_jifen.FH6) from T_jifen"

s_sql_tj = s_sql_tj + vbCrLf + " where T_jifen.FH3/100 = 4 and T_jifen.FH1 = T_RENYUAN.FH1 and year(T_jifen.FH5) = " + Now_Year + " and month(T_jifen.FH5) = " + Now_Month + " ) +150"

s_sql_tj = s_sql_tj + vbCrLf + " end,"

s_sql_tj = s_sql_tj + vbCrLf + " 谔谔 = case"

s_sql_tj = s_sql_tj + vbCrLf + " when (select sum(T_jifen.FH6) from T_jifen"

s_sql_tj = s_sql_tj + vbCrLf + " where T_jifen.FH3/100 = 5 and T_jifen.FH1 = T_RENYUAN.FH1 and year(T_jifen.FH5) = " + Now_Year + " and month(T_jifen.FH5) = " + Now_Month + " ) is null then 150"

s_sql_tj = s_sql_tj + vbCrLf + " else (select sum(T_jifen.FH6) from T_jifen"

s_sql_tj = s_sql_tj + vbCrLf + " where T_jifen.FH3/100 = 5 and T_jifen.FH1 = T_RENYUAN.FH1 and year(T_jifen.FH5) = " + Now_Year + " and month(T_jifen.FH5) = " + Now_Month + " ) + 150"

s_sql_tj = s_sql_tj + vbCrLf + " end,"

s_sql_tj = s_sql_tj + vbCrLf + " 谔谔 = case"

s_sql_tj = s_sql_tj + vbCrLf + " when (select sum(T_jifen.FH6) from T_jifen"

s_sql_tj = s_sql_tj + vbCrLf + " where T_jifen.FH3/100 = 6 and T_jifen.FH1 = T_RENYUAN.FH1 and year(T_jifen.FH5) = " + Now_Year + " and month(T_jifen.FH5) = " + Now_Month + " ) is null then 0"

s_sql_tj = s_sql_tj + vbCrLf + " else (select sum(T_jifen.FH6) from T_jifen"

s_sql_tj = s_sql_tj + vbCrLf + " where T_jifen.FH3/100 = 6 and T_jifen.FH1 = T_RENYUAN.FH1 and year(T_jifen.FH5) = " + Now_Year + " and month(T_jifen.FH5) = " + Now_Month + " )"

s_sql_tj = s_sql_tj + vbCrLf + " end,"
plutu 2003-07-10
  • 打赏
  • 举报
 回复
我在分析器中测试的也是这样的结果，我检查了，没有错误，本来我就是从表中select,然后insert 到另一个库中的，库结构也是复制过去的！
简易无忌 2003-07-10
  • 打赏
  • 举报
 回复
哈哈！快申报吉尼斯纪录吧~~~~~！90个字段的表？
CloneCenter 2003-07-10
  • 打赏
  • 举报
 回复
不是语句太长，而是字段的长度短了。要插入的值在字段中容纳不下。
zfl2k 2003-07-10
  • 打赏
  • 举报
 回复
String or binary data would be truncated.
The statement has been terminated.
--
字符串或二进制数据将被截断
语句被终止。

字段长度太小！
lxcc 2003-07-10
  • 打赏
  • 举报
 回复
是某个字段数据长度超过字段定义的长度
lxcc 2003-07-10
  • 打赏
  • 举报
 回复
是某个字段数据长度超过字段定义的长度
remanwang 2003-07-10
  • 打赏
  • 举报
 回复
90个字段？绝对是数据库设计的问题
frank_xpy 2003-07-10
  • 打赏
  • 举报
 回复
同意上面的，90个字段不算长！
lihonggen0 2003-07-10
  • 打赏
  • 举报
 回复
先在查询分析器中调试！
aiur2000 2003-07-10
  • 打赏
  • 举报
 回复
不错，写再长的我也写过，可以执行的，注意空格，变量什么的，还要看本身sql有没有错
加载更多回复（16）
2024华为OD机试D卷 - 最多购买宝石数目 - 免费看解析和代码.html
私信博主免费获取真题解析以及代码
华为OD机试D卷 - 小朋友来自多少小区 - 免费看解析和代码.html
私信博主免费获取真题解析以及代码
C51单片机的示例-课程实验-LCD1602基础开发库-内含源码和说明书.zip
C51单片机的示例-课程实验-LCD1602基础开发库-内含源码和说明书.zip
毕业设计 基于Python+Django+itemCF和userCF算法音乐推荐系统源码+详细文档+全部数据资料 高分项目
【资源说明】 毕业设计 基于Python+Django+itemCF和userCF算法音乐推荐系统源码+详细文档+全部数据资料 高分项目 【备注】 1、该项目是高分毕业设计项目源码，已获导师指导认可通过，答辩评审分达到95分 2、该资源内项目代码都经过测试运行成功，功能ok的情况下才上传的，请放心下载使用！ 3、本项目适合计算机相关专业(如软件工程、计科、人工智能、通信工程、自动化、电子信息等)的在校学生、老师或者企业员工下载使用，也可作为毕业设计、课程设计、作业、项目初期立项演示等，当然也适合小白学习进阶。 4、如果基础还行，可以在此代码基础上进行修改，以实现其他功能，也可直接用于毕设、课设、作业等。 欢迎下载，沟通交流，互相学习，共同进步！
setuptools-51.3.1-py3-none-any.whl
Python库是一组预先编写的代码模块，旨在帮助开发者实现特定的编程任务，无需从零开始编写代码。这些库可以包括各种功能，如数学运算、文件操作、数据分析和网络编程等。Python社区提供了大量的第三方库，如NumPy、Pandas和Requests，极大地丰富了Python的应用领域，从数据科学到Web开发。Python库的丰富性是Python成为最受欢迎的编程语言之一的关键原因之一。这些库不仅为初学者提供了快速入门的途径，而且为经验丰富的开发者提供了强大的工具，以高效率、高质量地完成复杂任务。例如，Matplotlib和Seaborn库在数据可视化领域内非常受欢迎，它们提供了广泛的工具和技术，可以创建高度定制化的图表和图形，帮助数据科学家和分析师在数据探索和结果展示中更有效地传达信息。
数据库(包含打印，安装，报表)

1,216

社区成员

55,954

社区内容

发帖
与我相关
我的任务
社区描述
VB 数据库(包含打印，安装，报表)
社区管理员
  • 数据库(包含打印，安装，报表)社区
加入社区
  • 近7日
  • 近30日
  • 至今

加载中

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

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

+ 用AI写文章