How should I write a column name in a database? between [] or a single word??

Question

If the column name is "Abc xyz" , is it better to write it [Abc xyz] or Abcxyz ???

Answer 1

I am not sure what database you are using but in MS Sql Server, and I assume other databases, you only need to use [] around a field when either it has a space in it, or when the field name is an SQL reserved word. For example if I have a field called From and I want to query it I would have to do:

select [From] from myTable

I find it best to avoid using spaces in field names and reserved words whenever possible, it's just makes things easier.