102 🗃️ SQL

SQL Server: Incorrect syntax near 'x'. (Msg 102)

T-SQL couldn’t parse the statement near the shown token.

Seen on: SQL

Meaning

MySQL/PostgreSQL syntax (LIMIT, backticks, ILIKE), missing commas, reserved words, or unsupported features for the compatibility level.

Common causes

  • LIMIT instead of TOP/OFFSET FETCH
  • Backticks instead of [brackets]
  • Reserved words as names
  • Old compatibility level

⚡ Quick fix

  1. Use TOP or OFFSET … FETCH
  2. Quote identifiers with [ ]
  3. Check the database compatibility level

Detailed fix by platform

SQL

  1. SELECT * FROM dbo.Orders ORDER BY Id OFFSET 20 ROWS FETCH NEXT 10 ROWS ONLY;

How to diagnose

  1. Token — Which one?
  2. Dialect — Non-T-SQL syntax?

🧠 Still stuck? Analyze your error

Paste the full message, response headers or stack trace — we'll detect the platform and point to the most likely cause.