how i can make the relation ship in MS SQL ?

Recommended Answers

All 2 Replies

That is such an open ended question that a short answer is impossible. Please provide more details. What are the tables you want to link and how are they related?

Hi All!
MS sql server follow the RDBMS & Cods concepts.
You can not enforce having row in child table by using constraints. (because you first insert row in parent table and only then in child table- its not one operation but 2, even though it most possibly one transaction)

But you can use stored procedure to insert data and you can do validation inside a procedure.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.