SQL Query Typos – SQL Server Problem

Summary

This article explains how to resolve the SQL Server problem of typos that prevent statement execution.

Symptoms

Often error messages in SQL generate from typos in the SQL statement. Long and complex queries are prone to small typos which will prevent the statement from executing.  The error messages can be difficult to interpret at times.

Explanation

Common typos seen:

• Missing commas between elements of a SELECT clause of a SELECT statement
• Incorrect field references in the FROM clause

Solution

Great care needs to be taken in writing the statement. This is especially true when using cut and paste to save time.

Additional Comments

Related Articles: “Error in SELECT clause: expression near ‘[field reference]’. Missing FROM clause.” – SQL Management Studio Error Message

“The multi-part identifier “[Select field]” could not be bound.” – KBA-01298

 

Author

---

Related Articles

• Replace a Database in SSMS – SQL Instructions
• Setting Up BreadCrumbs Server with SQL 2022 – Sigo Instructions
• Create ODBC OLE Data Source for CODESOFT – Instructions
• Create a View from an External Table with a Record ID in TEKLYNX CENTRAL – Instructions
• Configuring the External Database Feature – TEKLYNX CENTRAL Instructions
• Backup a SQL Database to a File – SQL Server Instruction Article