When you write your create table statements, always make sure
that you make them non-ambiguous. That way even though other
servers might have different configurations, you make sure your
table will be created in the same way.
Imagine for instance you are developing an application on a development server, nicely storing all the scripts you need to create the same database on your production server. If the same script creates a table differently on both servers, that might cause you a lot of headache later on. At Open Query, we strive to minimise (or preferrably eliminate) headaches.
One of the parts of the create table statement that …[Read more...]