11,848
社区成员
发帖
与我相关
我的任务
分享请各位MSSQL的高手们进来：String or binary data would be truncated.
NT4+SP6 中文版
MS SQL Server7.0 + SP2
SQL Server Query Analyzer
语句1：execute up_goods_distributingA '2001-10-01' , '2001-10-31' ,
' and season.minino = ''0000000A'' and fabclass.sysno in (''00000001'',''00000005'')'
语句2：execute up_goods_distributingA '2001-10-01' , '2001-10-31' ,
' and season.minino = ''0000000B'' and fabclass.sysno in (''00000001'',''00000005'')'
语句1执行正确，但语句2执行时错误：
Server: Msg 8152, Level 16, State 9, Line 1
String or binary data would be truncated.
The statement has been terminated.
何解？！
此过程定义头部如下：
CREATE procedure up_goods_distributingA
( @ld_frdate datetime = '1997-06-15' , @ld_todate datetime = '1997-06-15' ,
@ls_currwhere varchar(8000) = '' )
即使在服务器上执行也是如此
那位大师可以帮我
MS SQL Server7.0 + SP2
SQL Server Query Analyzer
语句1：execute up_goods_distributingA '2001-10-01' , '2001-10-31' ,
' and season.minino = ''0000000A'' and fabclass.sysno in (''00000001'',''00000005'')'
语句2：execute up_goods_distributingA '2001-10-01' , '2001-10-31' ,
' and season.minino = ''0000000B'' and fabclass.sysno in (''00000001'',''00000005'')'
语句1执行正确，但语句2执行时错误：
Server: Msg 8152, Level 16, State 9, Line 1
String or binary data would be truncated.
The statement has been terminated.
何解？！
此过程定义头部如下：
CREATE procedure up_goods_distributingA
( @ld_frdate datetime = '1997-06-15' , @ld_todate datetime = '1997-06-15' ,
@ls_currwhere varchar(8000) = '' )
即使在服务器上执行也是如此
那位大师可以帮我
...全文
请发表友善的回复…
发表回复
N_chow 2002-01-06
- 打赏
- 举报
呵呵~~~搞错了。
应该是
SET ANSI_WARNINGS OFF
应该是
SET ANSI_WARNINGS OFF
N_chow 2002-01-06
- 打赏
- 举报
SET ANSI_WARNINGS OFF
rwq_ 2002-01-06
- 打赏
- 举报
你定义的字段长度是不是太短了？
Rewiah 2002-01-06
- 打赏
- 举报
这个问题必须要看你存储过程的实现部分!
不想公布存储过程的细节恐怕只有自己解决了!
不想公布存储过程的细节恐怕只有自己解决了!
robert99 2002-01-06
- 打赏
- 举报
To:N_chow(一劍飄香++)
外甥打灯笼--照舅
外甥打灯笼--照舅
N_chow 2002-01-06
- 打赏
- 举报
在你的SQL 前面加上
SET ANSI_WARNINGS ON
強制性把訊息關掉。
SET ANSI_WARNINGS ON
強制性把訊息關掉。
已解决pymssql._mssql.MSSQLDatabaseException: (8152, b‘String or binary data would be truncated.DB-Lib e