Member Avatar for dana2292

how i can make the relation ship in MS SQL ?

  • 3 Contributors
  • 2 Replies
  • 221 Views
  • 2 Weeks Discussion Span
  • Latest Post Latest Post by pssingh1001
Member Avatar for Reverend Jim

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?

Member Avatar for pssingh1001

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.