THE SQL Server Blog Spot on the Web
Welcome to SQLblog.com - The SQL Server blog spot on the web
Browse by Tags
"Trusted" Foreign Keys Allow Orphans, Reject Valid Child Rows
In SQL 2008 R2, MERGE does not implement foreign keys properly. I will show both false negatives (valid rows are rejected) and false positives - orphan rows that are allowed to save. False Negatives The following tables implement a very common type/subtype pattern: CREATE TABLE dbo.Vehicles( ID INT NOT ...
October 17, 2011
Brought to you by