How to deal with SQL column names that look like SQL keywords?

by

Wrap the column name in brackets like so, from becomes [from].

select [from] from table;

It is also possible to use the following (useful when querying multiple tables):

select table.[from] from table;

More Related Contents:

  1. Add a column with a default value to an existing table in SQL Server
  2. NULL values inside NOT IN clause
  3. What is the best way to paginate results in SQL Server
  4. SQL MAX of multiple columns?
  5. Table Naming Dilemma: Singular vs. Plural Names [closed]
  6. SQL Server Process Queue Race Condition
  7. Is the NOLOCK (Sql Server hint) bad practice?
  8. SQL Server 2005 Pivot on Unknown Number of Columns
  9. Creating table names that are reserved words/keywords in MS SQL Server [closed]
  10. Dynamic SQL – EXEC(@SQL) versus EXEC SP_EXECUTESQL(@SQL)
  11. Get all dates between two dates in SQL Server
  12. SQL – Subtracting a depleting value from rows
  13. Stored procedure or function expects parameter which is not supplied
  14. Pass table as parameter into sql server UDF
  15. SQL Server Convert Varchar to Datetime
  16. There are no primary or candidate keys in the referenced table that match the referencing column list in the foreign key
  17. OPTION (RECOMPILE) is Always Faster; Why?
  18. SQL server query to get the list of columns in a table along with Data types, NOT NULL, and PRIMARY KEY constraints
  19. Compare DATETIME and DATE ignoring time portion
  20. Fastest way to determine if record exists
  21. SQL – Query to get server’s IP address
  22. Remove numbers from string sql server
  23. What is the equivalent of ‘describe table’ in SQL Server?
  24. How to concatenate many rows with same id in sql?
  25. How do I edit a table in order to enable CASCADE DELETE?
  26. How to select date without time in SQL
  27. Generate nested nth level JSON SQL Server using recursive CTE
  28. Update query using Subquery in Sql Server
  29. “SELECT DISTINCT” ignores different cases
  30. T-SQL: checking for email format

Leave a Comment