New answers tagged relational-theory
There is no declarative referential integrity to enforce one or more children in SQL Server. You have to enforce this with application logic. Note too that if you are using a foreign key constraint on the child, you can't save the child until the primary key of the parent is known. This means that you need to have a transactional wrapper (BEGIN TRAN / ...
Top 50 recent answers are included