Rules to Better Access Databases

Microsoft Gold Partner Logo
Search Go Search
Rule #1
Do use spaces in table names?
  v5.0 Posted at 20/10/2010 7:56 PM by system

Having spaces in table names necessitates the use of square brackets in all your code. e.g. [Order Details].[Order ID] instead of OrderDetail.OrderID. Spaces will also cause problems when you upsize to SQL Server later on... there is just no benefit.

Upsizing PRO will check this rule
 

Loading
Do you like this rule?
Loading
Do you follow this rule?
Loading

......