Incorrect syntax near

Question

I m trying to run the following fairly simple query in 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 totally correct  but I keep getting the following error      Msg 102  Level 15  State 1  Line 6   Incorrect syntax near       It works if I take out the join and only do a simple select   SELECT TOP 1000   FROM      master sys procedures as procs   But I need the join to work  I don t even have the string    in this query  so I can t figure out what it doesn t like

User · Answer

You can identify the encoding used for the file (in this case sql file) using an editor (I used Visual studio code). Once you open the file, it shows you the encoding of the file at the lower right corner on the editor.

encoding

I had this issue when I was trying to check-in a file that was encoded UTF-BOM (originating from a non-windows machine) that had special characters appended to individual string characters

You can change the encoding of your file as follows:

In the bottom bar of VSCode, you'll see the label UTF-8 With BOM. Click it. A popup opens. Click Save with encoding. You can now pick a new encoding for that file (UTF-8)

User · Answer

I was using ADO NET and was using SQL Command as    string query    SELECT        FROM table name     Where id  id     the thing was i missed a whitespace at the end of  FROM table name   So basically it said   string query    SELECT   FROM table nameWHERE id  id     and this was causing the error   Hope it helps

User · Answer

I got this error because I pasted alias columns into a DECLARE statement   DECLARE  userdata TABLE  f TABLE CATALOG nvarchar 100   f TABLE NAME nvarchar 100   f COLUMN NAME nvarchar 100   p COLUMN NAME nvarchar 100    SELECT   FROM  userdata    ERROR  Msg 102  Level 15  State 1  Line 2 Incorrect syntax near       DECLARE  userdata TABLE  f TABLE CATALOG nvarchar 100   f TABLE NAME nvarchar 100   f COLUMN NAME nvarchar 100   p COLUMN NAME nvarchar 100    SELECT   FROM  userdata   NO ERROR

User · Answer

The error for me was that I read the SQL statement from a text file  and the text file was saved in the UTF-8 with BOM  byte order mark  format   To solve this  I opened the file in Notepad   and under Encoding  chose UTF-8  Alternatively you can remove the first three bytes of the file with a hex editor

User · Answer

Panagiotis Kanavos is right  sometimes copy and paste T-SQL can make appear unwanted characters     I finally found a simple and fast way  only Notepad   needed  to detect which character is wrong  without having to manually rewrite the whole statement  there is no need to save any file to disk   It s pretty quick  in Notepad      Click  New file  Check under the menu  Encoding   the value should be  Encode in UTF-8   set it if it s not Paste your text  From Encoding menu  now click  Encode in ANSI  and check again your text    You should easily find the wrong character s

User · Answer

Such unexpected problems can appear when you copy the code from a web page or email and the text contains unprintable characters like individual CR or LF and non-breaking spaces

[sql] Incorrect syntax near ''

Examples related to sql

Examples related to sql-server

Examples related to ssms