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'.