Incorrect syntax near the keyword 'FROM'. in sp

Question

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)

Sujeet Raman · Answer

Tried but nothings print.if i give select ,returning null

Gaurav Kumar Sharma · Answer

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) print @selectcondition EXEC (@selectcondition) HI Karthik, try this Print the Query @selectcondition to identify the Exact Problem in the Query.

Sujeet Raman · Answer

none of the query is not working.returns null

Mageshwaran R · Answer

Hi Karthik, please try 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)

Rohit Rao · Answer

Try this: 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) add white space before your where clause, otherwise it will be merged with table name.

Incorrect syntax near the keyword 'FROM'. in sp

Answers (5)