home bbs files messages ]

Forums before death by AOL, social media and spammers... "We can't have nice things"

   comp.databases.ms-sqlserver      Notorious Rube Goldberg contraption      19,505 messages   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]

   Message 18,375 of 19,505   
   Erland Sommarskog to Gene Wirchenko   
   Re: SSE 2008: Check Clause Question   
   12 Jul 11 23:56:34   
   
   XPost: microsoft.public.sqlserver.programming   
   From: esquel@sommarskog.se   
      
   Gene Wirchenko (genew@ocis.net) writes:   
   >      Is there any way around the SQL glitch that a check condition   
   > will always succeed when the table is empty?   
   >   
   >      I do not want to have the first row be automatically accepted.   
      
   Not sure what you mean. If the table is empty, there is nothing to enforce.   
   That does not mean if you add a row, that anything will be accepted.   
      
   Could you clarify?   
      
   --   
   Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se   
      
   Links for SQL Server Books Online:   
   SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx   
   SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]


(c) 1994,  bbs@darkrealms.ca