Re: [Webware-discuss] cvs update: middlekit: misc enhancements

[Geoff T. <gta...@na...>]

Chuck Esterbrook wrote:

> Added SQLGenerator.sqlSupportsDefaultValues(self) so that concrete
> subclasses can advertise whether or not their CREATE statement supports
> DEFAULT <value>. (MySQL & PostgreSQL do; MSSQL does not.)

Here's an example pasted directly from the MS SQL Server 7.0 documentation:

CREATE TABLE test_defaults
    (keycol        smallint,
    process_id    smallint DEFAULT @@SPID,    --Preferred default definition
    date_ins    datetime DEFAULT getdate(),    --Preferred default definition
    mathcol        smallint DEFAULT 10 * 2,    --Preferred default definition
    char1        char(3),
    char2        char(3) DEFAULT 'xyz') --Preferred default definition

Perhaps earlier versions of MSSQL didn't allow DEFAULT in CREATE TABLE, but 7.0 does.

--


- Geoff Talvola
  Parlance Corporation
  gtalvola@NameConnector.com