TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
selvi subramanian
NA
799
574.5k
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'.
Reply
Answers (
3
)
sql server performance
Which TCP/IP Port Does SQL Server Run ON