数据转换中出现错误溢出 [英] Have an error overflow in data conversion
问题描述
连接数据时出错。
SET @ZYEAR = 2015
SET @ZPERIOD = 5
SET @STARTPERIOD = CONVERT(NVARCHAR,@ ZYEAR)+右('00'+转换(varchar(10), @ZPERIOD),2)
错误
Msg 244,级别16,状态2,过程sp_Construction,第176行
nvarchar值'201505'的转换溢出INT2列。使用更大的整数列。
如何更正它。
我有什么尝试过:
i已经检查过互联网和我的一些代码
Have an Error concatenating data.
SET @ZYEAR = 2015
SET @ZPERIOD = 5
SET @STARTPERIOD = CONVERT(NVARCHAR,@ZYEAR)+ Right('00' + Convert(varchar(10),@ZPERIOD), 2)
Error
Msg 244, Level 16, State 2, Procedure sp_Construction, Line 176
The conversion of the nvarchar value '201505' overflowed an INT2 column. Use a larger integer column.
How do I correct it.
What I have tried:
i HAVE CHECKED THE INTERNET AND SOME OF MY CODES
推荐答案
看看你的@STARTPERIOD声明 - 我怀疑它被声明为SMALLINT,它不能容纳大于32767的数字
Look at your declaration of @STARTPERIOD - I suspect it's declared as a SMALLINT, which can't hold numbers bigger than 32767
这篇关于数据转换中出现错误溢出的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!