How do you deal with blank spaces in column names in SQL Server?

by 
select [Response Status Code], [Client Response Status Code]
from TC_Sessions (NOLOCK) 
WHERE StartDate BETWEEN '05-15-2012' AND '06-01-2012' 
AND SupplyID = 3367

Wrap the names in square brackets.

It is , however, best to avoid spaces in names if possible. It just creates more work for you down the road…

More Related Contents:

  1. Updating image in VB and SQL Server not working [closed]
  2. Query to list number of records in each table in a database
  3. Storing a file in a database as opposed to the file system?
  4. Multiple Indexes vs Multi-Column Indexes
  5. Preferred Method of Storing Passwords In Database
  6. Using a sort order column in a database table
  7. Create a view with ORDER BY clause
  8. What does ‘COLLATE SQL_Latin1_General_CP1_CI_AS’ do?
  9. How to do version control for SQL Server database?
  10. What columns generally make good indexes?
  11. How to determine total number of open/active connections in ms sql server 2005
  12. How to check if a database exists in SQL Server?
  13. Getting execute permission to xp_cmdshell
  14. TSQL: Create a view that accesses multiple databases
  15. How to migrate a PostgreSQL database into a SQLServer one?
  16. What is the point of “Initial Catalog” in a SQL Server connection string?
  17. “Cannot open user default database. Login failed.” after installing SQL Server Management Studio Express
  18. How to create a yes/no boolean field in SQL server?
  19. Best way to store time (hh:mm) in a database
  20. How can I run just the statement my cursor is on in SQL Server Management Studio?
  21. Executing set of SQL queries using batch file?
  22. Database design: Calculating the Account Balance
  23. In SQL Server, how can I lock a single row in a way similar to Oracle’s “SELECT FOR UPDATE WAIT”?
  24. Date range overlapping check constraint
  25. What are the advantages of VistaDB
  26. Difference between database and schema
  27. Generate table relationship diagram from existing schema (SQL Server) [closed]
  28. Calculate Time Difference Between Two Rows
  29. What are the limitations to SQL Server Compact? (Or – how does one choose a database to use on MS platforms?)
  30. Tool for Scripting Table Data

Leave a Comment