hi please change the insert statement as follows.... insert into Student_Info (Stu_Code,Stu_Name,Sex,Nationality,Relagion,Address ,ZipCode,Phone,Mobile,Email,District,BirthPlace,BirthDate,Certificate_Type ,Certification,Department,Grad_Date,Total,Grade_Total,School_name,Stu_Image ,School_SeatNO,National_ID,Region,First_Choice,Second_Choice,Third_Choice ,First_Lang,Second_Lang) select @Stu_Code,Stu_Name,Sex,Nationality,Relagion ,Address,ZipCode,PhoneNO,Mobile,email,District,BirthPlace,BirthDate,Certificate_Type ,Certification,Department,Grad_Date,Total,Grade_Total,school_name,Stu_Image ,School_SeatNO,National_ID,Region,First_Choice,Second_Choice,Third_Choice ,First_Lang,Second_Lang from Student_Registry where Student_ID=@Stu_ID