SQL sever support in zeroCode
zeroCode now supports MS SQL Server. Here are some details.
To create an SQL-server-based site, you must have included suitable entries in the zdeAdmin database:
1 The Database_type table must include an entry whose description field contains the string ‘MS SQL Server’ (note that this string is case-sensitive).
2 An entry for an SQL server database engine in the Database_engine table, and this entry must have its type tied to the type entry above.
You can then use this database engine to create your site.
Create tables with keys that follow these rules:
The site creation process copies over the necessary JDBC driver into the generated site. To begin with, you could test this out using the eval version of the the driver available from http://www.jturbo.com. This will be contained in the file JTurbo.jar in the site’s stdlib directory. If, however, you do not wish to use this particular driver, it is upto you  to remove that jar file and use another one instead. More generally, the site creation process copies JDBC drivers for all supported platforms into the generated site’s stdlib directory, so that it is easy to re-target the site during the site testing process. You can choose to remove unnecessary drivers after completing the testing.
The SQL optimizer depends heavily on the choice of database type. It looks at the value of the database type parameter in the site’s config file, and if it finds ‘MS SQL Server’ as the value, it uses the ANSI outer join syntax; otherwise it uses the Oracle syntax for outer joins. So if you find syntax errors with outer joins in the generated site, you know where to look.