Thomas Steinmaurer wrote:

> >> Kjell Rilbe wrote:
> > Somehow it seems typical of a Microsoft product to do strange unexpected
> > things without telling anyone... And I though other FB enthusiasts like
> > me might find this example amusing. :-)
>
> Another amusing example is how MSSQL handles UNIQUE consraints with
> NULLable fields compared to all others. ;-))

Can you elaborate? I seem to recall that MSSQL allows only one NULL
record for unique constraints? Is it more common to ignore nulls
completely in unique constraint? Or is it the other way around? And
which one is more standard compliant?

Kjell
--
--------------------------------------
Kjell Rilbe
DataDIA AB
E-post: kjell@...
Telefon: 08-761 06 55
Mobil: 0733-44 24 64