Problem in Stored Procedure
-
Hi I m using this procedure and want to insert data in multiple table. First it insert data in ST_STUDENT which auto generates the 'Identity' value of 'Student_Code' which i want to use in other tables for 'Student_Code' field. I m using this line for getting the last generated 'Student_Code' but it gives me this error 'Expects Parameter '@STUDENT_CODE" WHICH WAS NOT SUPPLIED" what is wrong in my procedure. Kindly Tell me alter Procedure SP_INSERT_STUDENT_COMPLETEINFO_BYAGENT @STUDENT_CODE varchar(4), @FIRST_NAME VARCHAR(50), @LAST_NAME VARCHAR(50), @EMAIL_ADDRESS VARCHAR(50), @HOME_PHONE VARCHAR(50), @HOMEEXT VARCHAR(10), @OFFICE_PHONE VARCHAR(50), @OFFICEEXT VARCHAR(50), @MOBILE VARCHAR(50), @HIGHEST_EDUCATION_LEVEL VARCHAR(50), @DOB DATETime, @COUNTRY_OF_RESIDENCE VARCHAR(50), @COUNTRY_OF_NATIONALITY VARCHAR(50), @US_SECURITY_NUMBER VARCHAR(50), @GENDER VARCHAR(20), @MARITAL_STATUS VARCHAR(20), @ETHNIC_GROUP VARCHAR(20), AS INSERT INTO ST_STUDENT(FIRST_NAME,LAST_NAME,EMAIL_ADDRESS,HOME_PHONE,HOMEEXT,OFFICE_PHONE,OFFICEEXT,MOBILE) VALUES(@FIRST_NAME,@LAST_NAME,@EMAIL_ADDRESS,@HOME_PHONE,@HOMEEXT,@OFFICE_PHONE,@OFFICEEXT,@MOBILE) SET @STUDENT_CODE =(SELECT @@IDENTITY) Insert into ST_STUDENTBIODATA(HIGHEST_EDUCATION_LEVEL,DOB,COUNTRY_OF_RESIDENCE,COUNTRY_OF_NATIONALITY, US_SECURITY_NUMBER,GENDER,MARITAL_STATUS,ETHNIC_GROUP,STUDENT_CODE) VALUES(@HIGHEST_EDUCATION_LEVEL,@DOB,@COUNTRY_OF_RESIDENCE,@COUNTRY_OF_NATIONALITY,@US_SECURITY_NUMBER,@GENDER,@MARITAL_STATUS, @ETHNIC_GROUP,@STUDENT_CODE) GO Regards
-
Hi I m using this procedure and want to insert data in multiple table. First it insert data in ST_STUDENT which auto generates the 'Identity' value of 'Student_Code' which i want to use in other tables for 'Student_Code' field. I m using this line for getting the last generated 'Student_Code' but it gives me this error 'Expects Parameter '@STUDENT_CODE" WHICH WAS NOT SUPPLIED" what is wrong in my procedure. Kindly Tell me alter Procedure SP_INSERT_STUDENT_COMPLETEINFO_BYAGENT @STUDENT_CODE varchar(4), @FIRST_NAME VARCHAR(50), @LAST_NAME VARCHAR(50), @EMAIL_ADDRESS VARCHAR(50), @HOME_PHONE VARCHAR(50), @HOMEEXT VARCHAR(10), @OFFICE_PHONE VARCHAR(50), @OFFICEEXT VARCHAR(50), @MOBILE VARCHAR(50), @HIGHEST_EDUCATION_LEVEL VARCHAR(50), @DOB DATETime, @COUNTRY_OF_RESIDENCE VARCHAR(50), @COUNTRY_OF_NATIONALITY VARCHAR(50), @US_SECURITY_NUMBER VARCHAR(50), @GENDER VARCHAR(20), @MARITAL_STATUS VARCHAR(20), @ETHNIC_GROUP VARCHAR(20), AS INSERT INTO ST_STUDENT(FIRST_NAME,LAST_NAME,EMAIL_ADDRESS,HOME_PHONE,HOMEEXT,OFFICE_PHONE,OFFICEEXT,MOBILE) VALUES(@FIRST_NAME,@LAST_NAME,@EMAIL_ADDRESS,@HOME_PHONE,@HOMEEXT,@OFFICE_PHONE,@OFFICEEXT,@MOBILE) SET @STUDENT_CODE =(SELECT @@IDENTITY) Insert into ST_STUDENTBIODATA(HIGHEST_EDUCATION_LEVEL,DOB,COUNTRY_OF_RESIDENCE,COUNTRY_OF_NATIONALITY, US_SECURITY_NUMBER,GENDER,MARITAL_STATUS,ETHNIC_GROUP,STUDENT_CODE) VALUES(@HIGHEST_EDUCATION_LEVEL,@DOB,@COUNTRY_OF_RESIDENCE,@COUNTRY_OF_NATIONALITY,@US_SECURITY_NUMBER,@GENDER,@MARITAL_STATUS, @ETHNIC_GROUP,@STUDENT_CODE) GO Regards
You have a comma just before your AS.