将int转换为数据类型numeric的算术溢出错误。 - 如何将Int转换为数字 [英] Arithmetic overflow error converting int to data type numeric. - How to convert Int to Numeric

问题描述

以下代码会将Int抛出数字转换错误。



请帮帮我。

Hi,

The following code throws "Int" to "numeric" conversion error.

Please help me out.

Begin
declare @tmptble TABLE(EmpId nvarchar(10),EmpMonth numeric(2,0),EmpYear numeric(4,0))
insert into @tmptble(EmpId,EmpMonth,EmpYear)
select emp_CDSID,MONTH(getdate()),YEAR(getdate()) from Employee
	declare @count numeric(2,0)
	declare @empid nvarchar(10)
	declare @month numeric(2,0)
	declare @year numeric(4,0)
	set @count = (select count(*) from @tmptble)
declare FirstCursor cursor for select EmpId,EmpMonth,EmpYear from @tmptble									
open FirstCursor																				
while (@count>0)
  begin
	fetch FirstCursor into @empid,@month,@year
	set @existsAttendance = (select count(*) from Attendance where EmpId=@empid and EmpMonth=@month and EmpYear=@year)
	-- [ ATTENDANCE INSERT ] --
	if (@existsAttendance = 0)
	   begin
           Insert into CDSI_DB.dbo.Attendance(EmpId,EmpMonth,EmpYear,SG,S1,S2,W,W1,W2,LOP,CO,SPL,OD,H) values(UPPER(@empid),@month,@year,0,0,0,0,0,0,0,0,0,0,0)
 	   end
          set @count=@count-1	
  end
       close FirstCursor
End

并且，出勤表将EmpMonth和EmpYear作为数值数据类型。

And, "Attendance table has EmpMonth and EmpYear as numeric datatype.

推荐答案

使用此：

Use this:

declare @tmptble TABLE(Col1 nvarchar(10),Col2 INT,Col3 INT) 

insert into @tmptble(Col1,Col2,Col3) 
select ID, MONTH(getdate()), YEAR(getdate())
from Employee

月 [ ^ ]和年 [ ^ ]功能返回整数数据类型;）

Month[^] and Year[^] funtion return Integer data type ;)

该行怎么样：

What about that line:

declare @count numeric(2,0)

发生了吗？计数大于99？

Did it happen that the count was greater than 99?

确保临时表列的数据类型与表的列相同。





如果解决了您的问题，请选择答案。



问候，

Dheeraj Gupta

Make sure that your temp table columns having same datatype as of your table's column.


Mark as answer if solved your query.

Regards,
Dheeraj Gupta

这篇关于将int转换为数据类型numeric的算术溢出错误。 - 如何将Int转换为数字的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！