Incorrect syntax near the keyword 'FROM'. in sp

Sujeet Raman

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)

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sujeet Raman6y ago
Tried but nothings print.if i give select ,returning null
+1
Gaurav Kumar Sharma6y ago
1. 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)
2. print @selectcondition
3. EXEC (@selectcondition)
HI Karthik,

try this Print the Query @selectcondition to identify the Exact Problem in the Query.
+1

Sujeet Raman6y ago

none of the query is not working.returns null

Mageshwaran R6y ago

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 Rao6y ago

Try this:

EXEC (@selectcondition)

add white space before your where clause, otherwise it will be merged with table name.