10 TIPs - To Become a Good Developer/Programmer
Why Join
Become a member
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
C# Corner Home
Technologies
Monthly Leaders
ASK A QUESTION
Forum guidelines
Sabeesh V4u
1.3k
766
215k
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