Re: Create Table

Is it possible to set something in the SQLServer so that it can have more strict ANSI SQL checking, for example the following statement should fail:

create table bb
(user1 int
,user2 char(29) default user
)

On Thu, 9 Jul 1998, Anthony Mandic wrote:

> Ngkpo John wrote:
> >
> > Another Testing, this time I remove the single extraneous comman at the
> > end of the first line,
> >
> > create table bb ( cc int, b int
> > constraint cc primary key (cc)
> > )
> >
> > MSSQL:OK
> > Oracle:Fail
> > Sybase:Fail
> >
> > Don Macpherson wrote:
> <
> < > Presumably 2> fails on Oracle due to the single extraneous comma at
> < > the end of the first line.
> < > According to the SQL92 standard (Entry, Intermediate or Full), this
> < > should fail.
> < >
>
> He meant the comma in the second example, i.e. the one before
> the comment line, ... , -- ...) wouldn't be a valid parse.
> Not surprised MS failed to pick the syntax error.
>
> -am
>
>
Received on Thu Jul 09 1998 - 00:00:00 CDT