selvi subramanian

selvi subramanian

  • NA
  • 799
  • 572.7k

what error in this store procedure

Jul 22 2012 2:29 AM
CREATE PROCEDURE insert_selvi
@name varchar(20),@gender varchar(10),@education varchar(20),@comname varchar(20),@designation varchar(20),@location varchar(30),@emailid varchar(30),@mobile bigint,@phone bigint


AS
BEGIN
insert into swathi (name,gender,education,comname,designation,location,emailid,mobile,phone)


SELECT @name,@gender,@education,@comname,@designation,@location,@emailid,@mobile,@phone
END





It throws error 




Msg 207, Level 16, State 1, Procedure insert_selvi, Line 7
Invalid column name 'gender'.
Msg 207, Level 16, State 1, Procedure insert_selvi, Line 7
Invalid column name 'education'.
Msg 207, Level 16, State 1, Procedure insert_selvi, Line 7
Invalid column name 'comname'.
Msg 207, Level 16, State 1, Procedure insert_selvi, Line 7
Invalid column name 'designation'.
Msg 207, Level 16, State 1, Procedure insert_selvi, Line 7
Invalid column name 'location'.
Msg 207, Level 16, State 1, Procedure insert_selvi, Line 7
Invalid column name 'emailid'.
Msg 207, Level 16, State 1, Procedure insert_selvi, Line 7
Invalid column name 'mobile'.
Msg 207, Level 16, State 1, Procedure insert_selvi, Line 7
Invalid column name 'phone'.


Answers (3)