Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by JOM1488
-
Foreign Key validations in MSSQL
It's not a default issue. Microsoft informed us that MS implements Foreign Keys differently from other databases. Thus for MS the only real solution for composite foreign keys is to replace the Foreign Key validation with triggers. Pain in the %&$#!.- JOM1488
- Post #3
- Forum: Microsoft SQL Server: Programming
-
Foreign Key validations in MSSQL
MSSQL v7 appears to validate foreign keys differently from Oracle and Sybase ASA.<br> In MSSQL if you have a table which validates both a State and City field against a City table (which includes the state) then MSSQL appears to REQUIRE you to include the City field in the update statement even...- JOM1488
- Thread
- Replies: 2
- Forum: Microsoft SQL Server: Programming
