{"id":34170,"date":"2023-03-02T14:37:40","date_gmt":"2023-03-02T09:07:40","guid":{"rendered":"https:\/\/jassweb.com\/solved\/solved-relationship-between-tables-in-ms-sql-server-closed\/"},"modified":"2023-03-02T14:37:40","modified_gmt":"2023-03-02T09:07:40","slug":"solved-relationship-between-tables-in-ms-sql-server-closed","status":"publish","type":"post","link":"https:\/\/jassweb.com\/solved\/solved-relationship-between-tables-in-ms-sql-server-closed\/","title":{"rendered":"[Solved] Relationship between tables in ms sql server [closed]"},"content":{"rendered":"<p> [ad_1]<br \/>\n<\/p>\n<div id=\"answer-43680113\" class=\"answer js-answer accepted-answer js-accepted-answer\" data-answerid=\"43680113\" data-parentid=\"43679989\" data-score=\"0\" data-position-on-page=\"1\" data-highest-scored=\"1\" data-question-has-accepted-highest-score=\"1\" itemprop=\"acceptedAnswer\" itemscope itemtype=\"https:\/\/schema.org\/Answer\">\n<div class=\"post-layout\">\n<div class=\"votecell post-layout--left\"><\/div>\n<div class=\"answercell post-layout--right\">\n<div class=\"s-prose js-post-body\" itemprop=\"text\">\n<p>your table structure should be below<\/p>\n<p><strong>PatientTable<\/strong><br \/>\nPatientId   int Primary Key,<br \/>\nPatientName varchar(50),<br \/>\nEmailId varchar(50)<br \/>\nPassword  varchar(50)<\/p>\n<p><strong>TestTable<\/strong><br \/>\nTestId  int Primary key,<br \/>\nTestName varchar(50)<\/p>\n<p><strong>PatientTestTable<\/strong><br \/>\nPatientId int FK(PatientTable)<br \/>\nTestId int FK (TestTable)<\/p>\n<p>This way you can give relationship to two tables. you need to understand funamental of RDBMS. <\/p>\n<\/p><\/div>\n<div class=\"mt24\"><\/div>\n<\/div>\n<p>            <span class=\"d-none\" itemprop=\"commentCount\">1<\/span> <\/p><\/div>\n<\/div>\n<p>[ad_2]<\/p>\n<p>solved Relationship between tables in ms sql server [closed] <\/p>\n","protected":false},"excerpt":{"rendered":"<p>[ad_1] your table structure should be below PatientTable PatientId int Primary Key, PatientName varchar(50), EmailId varchar(50) Password varchar(50) TestTable TestId int Primary key, TestName varchar(50) PatientTestTable PatientId int FK(PatientTable) TestId int FK (TestTable) This way you can give relationship to two tables. you need to understand funamental of RDBMS. 1 [ad_2] solved Relationship between tables &#8230; <a title=\"[Solved] Relationship between tables in ms sql server [closed]\" class=\"read-more\" href=\"https:\/\/jassweb.com\/solved\/solved-relationship-between-tables-in-ms-sql-server-closed\/\" aria-label=\"More on [Solved] Relationship between tables in ms sql server [closed]\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[320],"tags":[500],"class_list":["post-34170","post","type-post","status-publish","format-standard","hentry","category-solved","tag-sql-server"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>[Solved] Relationship between tables in ms sql server [closed] - JassWeb<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/jassweb.com\/solved\/solved-relationship-between-tables-in-ms-sql-server-closed\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"[Solved] Relationship between tables in ms sql server [closed] - JassWeb\" \/>\n<meta property=\"og:description\" content=\"[ad_1] your table structure should be below PatientTable PatientId int Primary Key, PatientName varchar(50), EmailId varchar(50) Password varchar(50) TestTable TestId int Primary key, TestName varchar(50) PatientTestTable PatientId int FK(PatientTable) TestId int FK (TestTable) This way you can give relationship to two tables. you need to understand funamental of RDBMS. 1 [ad_2] solved Relationship between tables ... Read more\" \/>\n<meta property=\"og:url\" content=\"https:\/\/jassweb.com\/solved\/solved-relationship-between-tables-in-ms-sql-server-closed\/\" \/>\n<meta property=\"og:site_name\" content=\"JassWeb\" \/>\n<meta property=\"article:published_time\" content=\"2023-03-02T09:07:40+00:00\" \/>\n<meta name=\"author\" content=\"Kirat\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Kirat\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-relationship-between-tables-in-ms-sql-server-closed\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-relationship-between-tables-in-ms-sql-server-closed\/\"},\"author\":{\"name\":\"Kirat\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31\"},\"headline\":\"[Solved] Relationship between tables in ms sql server [closed]\",\"datePublished\":\"2023-03-02T09:07:40+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-relationship-between-tables-in-ms-sql-server-closed\/\"},\"wordCount\":69,\"publisher\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\"},\"keywords\":[\"sql-server\"],\"articleSection\":[\"Solved\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-relationship-between-tables-in-ms-sql-server-closed\/\",\"url\":\"https:\/\/jassweb.com\/solved\/solved-relationship-between-tables-in-ms-sql-server-closed\/\",\"name\":\"[Solved] Relationship between tables in ms sql server [closed] - JassWeb\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#website\"},\"datePublished\":\"2023-03-02T09:07:40+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-relationship-between-tables-in-ms-sql-server-closed\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/jassweb.com\/solved\/solved-relationship-between-tables-in-ms-sql-server-closed\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-relationship-between-tables-in-ms-sql-server-closed\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/jassweb.com\/solved\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"[Solved] Relationship between tables in ms sql server [closed]\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/jassweb.com\/solved\/#website\",\"url\":\"https:\/\/jassweb.com\/solved\/\",\"name\":\"JassWeb\",\"description\":\"Build High-quality Websites\",\"publisher\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/jassweb.com\/solved\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\",\"name\":\"Jass Web\",\"url\":\"https:\/\/jassweb.com\/solved\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png\",\"contentUrl\":\"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png\",\"width\":693,\"height\":132,\"caption\":\"Jass Web\"},\"image\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31\",\"name\":\"Kirat\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1776403586\",\"contentUrl\":\"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1776403586\",\"caption\":\"Kirat\"},\"sameAs\":[\"http:\/\/jassweb.com\"],\"url\":\"https:\/\/jassweb.com\/solved\/author\/jaspritsinghghumangmail-com\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"[Solved] Relationship between tables in ms sql server [closed] - JassWeb","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/jassweb.com\/solved\/solved-relationship-between-tables-in-ms-sql-server-closed\/","og_locale":"en_US","og_type":"article","og_title":"[Solved] Relationship between tables in ms sql server [closed] - JassWeb","og_description":"[ad_1] your table structure should be below PatientTable PatientId int Primary Key, PatientName varchar(50), EmailId varchar(50) Password varchar(50) TestTable TestId int Primary key, TestName varchar(50) PatientTestTable PatientId int FK(PatientTable) TestId int FK (TestTable) This way you can give relationship to two tables. you need to understand funamental of RDBMS. 1 [ad_2] solved Relationship between tables ... Read more","og_url":"https:\/\/jassweb.com\/solved\/solved-relationship-between-tables-in-ms-sql-server-closed\/","og_site_name":"JassWeb","article_published_time":"2023-03-02T09:07:40+00:00","author":"Kirat","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Kirat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/jassweb.com\/solved\/solved-relationship-between-tables-in-ms-sql-server-closed\/#article","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/solved-relationship-between-tables-in-ms-sql-server-closed\/"},"author":{"name":"Kirat","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31"},"headline":"[Solved] Relationship between tables in ms sql server [closed]","datePublished":"2023-03-02T09:07:40+00:00","mainEntityOfPage":{"@id":"https:\/\/jassweb.com\/solved\/solved-relationship-between-tables-in-ms-sql-server-closed\/"},"wordCount":69,"publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"keywords":["sql-server"],"articleSection":["Solved"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/jassweb.com\/solved\/solved-relationship-between-tables-in-ms-sql-server-closed\/","url":"https:\/\/jassweb.com\/solved\/solved-relationship-between-tables-in-ms-sql-server-closed\/","name":"[Solved] Relationship between tables in ms sql server [closed] - JassWeb","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/#website"},"datePublished":"2023-03-02T09:07:40+00:00","breadcrumb":{"@id":"https:\/\/jassweb.com\/solved\/solved-relationship-between-tables-in-ms-sql-server-closed\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/jassweb.com\/solved\/solved-relationship-between-tables-in-ms-sql-server-closed\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/jassweb.com\/solved\/solved-relationship-between-tables-in-ms-sql-server-closed\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/jassweb.com\/solved\/"},{"@type":"ListItem","position":2,"name":"[Solved] Relationship between tables in ms sql server [closed]"}]},{"@type":"WebSite","@id":"https:\/\/jassweb.com\/solved\/#website","url":"https:\/\/jassweb.com\/solved\/","name":"JassWeb","description":"Build High-quality Websites","publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/jassweb.com\/solved\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/jassweb.com\/solved\/#organization","name":"Jass Web","url":"https:\/\/jassweb.com\/solved\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/","url":"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png","contentUrl":"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png","width":693,"height":132,"caption":"Jass Web"},"image":{"@id":"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31","name":"Kirat","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/image\/","url":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1776403586","contentUrl":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1776403586","caption":"Kirat"},"sameAs":["http:\/\/jassweb.com"],"url":"https:\/\/jassweb.com\/solved\/author\/jaspritsinghghumangmail-com\/"}]}},"_links":{"self":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/34170","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/comments?post=34170"}],"version-history":[{"count":0,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/34170\/revisions"}],"wp:attachment":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/media?parent=34170"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/categories?post=34170"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/tags?post=34170"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}