how i can make the relation ship in MS SQL ?
dana2292 0 Newbie Poster
Recommended Answers
Jump to PostThat 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?
All 2 Replies
Reverend Jim 5,225 Hi, I'm Jim, one of DaniWeb's moderators. Moderator Featured Poster
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?
pssingh1001 0 Newbie Poster
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.