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
Sujeet Raman
752
927
354.1k
Incorrect syntax near the keyword 'FROM'. in sp
Aug 31 2020 12:56 PM
my sp returning the error
Msg 156, Level 15, State 1, Line 13
Incorrect syntax near the keyword 'FROM'.
all from key word i have checked and its fine.why this issue is coming .If i remove below code,its working what error in this query?
set @selectcondition ='SELECT '+CONVERT(VARCHAR(10),@id1) + '= id1, '+@id2+' = id2,'+ @FieldName+' = FieldName, '+@Description+' = Description,'+ CONVERT(VARCHAR(10),@id3) +' = id3 FROM '+ @MessageOutput+ 'WHERE ID = '+ CONVERT(VARCHAR(10),@result)
EXEC (@selectcondition)
Reply
Answers (
5
)
Asp.Net Web API
How to create insert a row using c# interop