>>Why do you need brackets around the fields when working with SQL Server? I think you only need the brackets if the field name is a reserved word in SQL Server.
>
>
>Yes, you only need them around reserved words. But, have you seen the reserved words list?? It's very long. And its hard to avoid using some of them. So, a safety-net approach is to surround each table name and field name with [ ]. Problem solved.
Or use prefixes for all your fields, that works as well.