Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 Data Corruption Issues
 Data in Foreign table not reference primary table

Author  Topic 

tahatran
Starting Member

1 Post

Posted - 2012-03-26 : 23:38:02
My Data Error
Example:
Table: NHAP
—————
ID | DateTime |
—————
1 | 20/2/2012|
2 | 20/3/2012|

Table: NHAPCT
————-
ID | SL | DG
————-
1 | 2 | 200
1 | 2 | 500
2 | 20 | 400
3 | 30 | 700 <– This is Error

Pic:


My data has more than 70 tables and 50 FK. I want to test all FK.
which method. Thanks

Data:
http://www.mediafire.com/?z4azgwc2jwcx1om
   

- Advertisement -