Re: check constraints and null values

From: Gail Erickson [MS] (gaile_at_online.microsoft.com)
Date: 01/14/05


Date: Fri, 14 Jan 2005 10:23:57 -0800

If you have not already done so, please use the doc feedback tool (the
little envelope) on the upper left hand corner of the incorrect topic so
that we can get this corrected.

Thanks,

-- 
Gail Erickson [MS]
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights
"David Portas" <REMOVE_BEFORE_REPLYING_dportas@acm.org> wrote in message 
news:F_GdnVEnYZkCA3jcRVn-2w@giganews.com...
> You are right. Books Online has it wrong.
> mk:@MSITStore:C:\Program%20Files\Microsoft%20SQL%20Server\80\Tools\Books\architec.chm::/8_ar_da_0777.htm
>
> SQL Server follows the ANSI / ISO Standard behaviour for CHECK and FOREIGN 
> KEY constraints:  values that are *not FALSE* are permitted. I think it's 
> safe to assume that the designers' intention was that this should be the 
> case and that Books Online is in error :-).
>
> -- 
> David Portas
> SQL Server MVP
> --
>
> 


Relevant Pages

  • Re: Query training -- Complex queries
    ... > Update PositionsEOM ... Here you don't have a derived table, but a correlated subquery. ... UPDATE in Books Online. ... is not written for SQL Server. ...
    (microsoft.public.sqlserver.server)
  • Re: OUT OF MEMORY
    ... you are saying that the default upper limit is 128k when created? ... Hitchhiker's Guide to Visual Studio and SQL Server ... and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook) ...
    (microsoft.public.sqlserver.ce)
  • Re: Linked Server: How to check if server exists?
    ... The root problem is described in the Books Online topic Batches. ... Rick Byham, SQL Server Books Online ... linked server don't run on those development machines not having that linked ...
    (microsoft.public.sqlserver.connect)
  • Re: STORED PROCEDURE - passing table name as a parameter
    ... T-SQL, is that you get problems if the view definition does not fit into ... will need to query other system tables, for instance syscolumns. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)
  • Re: Problem when changing Views
    ... There aree several reasons. ... I use neither of the tools, but I guess that Design View resubmits the ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)