Incorrect syntax near ''

Question

I had been trying to run the below simple  SQL query in the SQL Server Management Studio:

SELECT TOP 1000 * 

FROM 

    master.sys.procedures as procs

left join 

    master.sys.parameters as params on procs.object_id = params.object_id

This seems like totally correct, but I am getting the below error:

Msg 102, Level 15, State 1, Line 6

Incorrect syntax near ''.

It works if I am taking out the join and only do a simple select:

SELECT TOP 1000 *

FROM 

    master.sys.procedures as procs

But I want the join to be working. I do not also have the string '' in this query, so I can not figure out what it does not like.

Answer 1

Such unanticipated problems can arrive when you are copying the code from a web page or an email and the texts will be containing unprintable characters like individual CR or LF and non-breaking spaces.

Check out this SQL Tutorial for more insights.

Want to be a SQL expert? Come and join this SQL Certification by Intellipaat.

For more information visit :