Copy the Data to Temporary table using cursor in stored procedure getting error?

See more:

SQL-Server

SQL-Server-2008

, +

source:

CREATE PROCEDURE Balu_Cursor
AS
BEGIN
DECLARE @EmptypeID INT
DECLARE @Name VARCHAR(50)
DECLARE @Salary INT

DECLARE @TempTable table(
EmpID INT,
Empname varchar,
Salary numeric
)
DECLARE cur_print CURSOR FOR
SELECT Empno,Empname,Salary
FROM tblEmployee OPEN cur_print
FETCH NEXT FROM cur_print INTO @EmptypeID,@Name,@Salary

WHILE @@FETCH_STATUS = 0
BEGIN
insert into @TempTable(EmpID,Empname,Salary)values(@EmptypeID,@Name,@Salary)
PRINT @EmptypeID PRINT @Name PRINT @Salary
Select @EmptypeID as EmpNo,@Name Name,@Salary Salary from tblEmployee where Empno=@EmptypeID
FETCH NEXT FROM cur_print INTO @EmptypeID,@Name,@Salary
END
CLOSE cur_print
DEALLOCATE cur_print
END

ERROR:

Msg 8152, Level 16, State 14, Line 18
String or binary data would be truncated.
The statement has been terminated.