{"id":5953,"date":"2015-01-30T23:59:35","date_gmt":"2015-01-31T04:59:35","guid":{"rendered":"http:\/\/bangla.salearningschool.com\/?p=5953"},"modified":"2015-09-03T08:13:29","modified_gmt":"2015-09-03T12:13:29","slug":"%e0%a6%8f%e0%a6%b8%e0%a6%95%e0%a6%bf%e0%a6%89%e0%a6%8f%e0%a6%b2-%e0%a6%ab%e0%a6%b0%e0%a7%87%e0%a6%a8-%e0%a6%95%e0%a6%bf-%e0%a6%95%e0%a6%a8%e0%a7%8d%e0%a6%b8%e0%a6%9f%e0%a7%8d%e0%a6%b0%e0%a7%87","status":"publish","type":"post","link":"http:\/\/bangla.sitestree.com\/?p=5953","title":{"rendered":"\u098f\u09b8\u0995\u09bf\u0989\u098f\u09b2 \u09ab\u09b0\u09c7\u09a8 \u0995\u09bf \u0995\u09a8\u09cd\u09b8\u099f\u09cd\u09b0\u09c7\u0987\u09a8\u09cd\u099f ."},"content":{"rendered":"<p>\u098f\u09b8\u0995\u09bf\u0989\u098f\u09b2 \u09ab\u09b0\u09c7\u09a8 \u0995\u09bf \u0995\u09a8\u09cd\u09b8\u099f\u09cd\u09b0\u09c7\u0987\u09a8\u09cd\u099f<br \/>\nSheikh Mahfuzur Rahman<\/p>\n<p>\u098f\u0995\u099f\u09bf \u099f\u09c7\u09ac\u09b2\u09c7\u09b0 FOREIGHN KEY \u0985\u09a8\u09cd\u09af \u099f\u09c7\u09ac\u09b2\u09c7\u09b0 PRIMARY KEY \u098f\u09b0 \u09a6\u09bf\u0995\u09c7 \u09a8\u09bf\u09b0\u09cd\u09a6\u09c7\u09b6 \u0995\u09b0\u09c7\u0964 \u098f\u0995\u099f\u09bf \u0989\u09a6\u09be\u09b9\u09b0\u09a3\u09c7\u09b0 \u09ae\u09be\u09a7\u09cd\u09af\u09ae\u09c7 &#8220;\u09ab\u09b0\u09c7\u09a8 \u0995\u09bf&#8221; \u0995\u09c7 \u09ac\u09cd\u09af\u09be\u0996\u09cd\u09af\u09be \u0995\u09b0\u09be \u09af\u09be\u0995\u0964 \u09a8\u09bf\u099a\u09c7\u09b0 \u09a6\u09c1\u099f\u09cb \u099f\u09c7\u09ac\u09b2\u09c7\u09b0 \u09a6\u09bf\u0995\u09c7 \u09b2\u0995\u09cd\u09b7\u09cd\u09af \u0995\u09b0\u09c1\u09a8 \u09af\u09be\u09b0 \u098f\u0995\u099f\u09bf \u09b9\u09b2\u09cb &#8221;Persons&#8221; \u099f\u09c7\u09ac\u09b2 \u098f\u09ac\u0982 \u0985\u09a8\u09cd\u09af\u099f\u09bf \u09b9\u09b2\u09cb &#8220;Orders\u201d \u099f\u09c7\u09ac\u09b2\u0983<\/p>\n<p>The &#8220;Persons&#8221; table:<br \/>\nP_Id<br \/>\nLastName<br \/>\nFirstName<br \/>\nAddress<br \/>\nCity<br \/>\n1<br \/>\nHansen<br \/>\nOla<br \/>\nTimoteivn 10<br \/>\nSandnes<br \/>\n2<br \/>\nSvendson<br \/>\nTove<br \/>\nBorgvn 23<br \/>\nSandnes<br \/>\n3<br \/>\nPettersen<br \/>\nKari<br \/>\nStorgt 20<br \/>\nStavanger<br \/>\nThe &#8220;Orders&#8221; table:<br \/>\nO_Id<br \/>\nOrderNo<br \/>\nP_Id<br \/>\n1<br \/>\n77895<br \/>\n3<br \/>\n2<br \/>\n44678<br \/>\n3<br \/>\n3<br \/>\n22456<br \/>\n2<br \/>\n4<br \/>\n24562<br \/>\n1<\/p>\n<p>\u09b2\u0995\u09cd\u09b7\u09cd\u09af \u0995\u09b0\u09c1\u09a8, &#8220;Orders&#8221;\u099f\u09c7\u09ac\u09b2\u09c7\u09b0 &#8220;P_Id\u201d \u0995\u09b2\u09be\u09ae &#8221;Persons\u201d \u099f\u09c7\u09ac\u09b2\u09c7\u09b0 &#8221;P_Id\u201d \u0995\u09b2\u09be\u09ae\u09c7\u09b0 \u09a6\u09bf\u0995\u09c7 \u09a8\u09bf\u09b0\u09cd\u09a6\u09c7\u09b6 \u0995\u09b0\u099b\u09c7\u0964 \u09a4\u09be\u0987 \u098f\u0996\u09be\u09a8\u09c7 &#8221;Persons\u201d \u099f\u09c7\u09ac\u09b2\u09c7\u09b0 &#8220;P_Id\u201d \u0995\u09b2\u09be\u09ae \u09b9\u09b2\u09cb \u098f\u0987 \u099f\u09c7\u09ac\u09b2\u09c7\u09b0 \u09aa\u09cd\u09b0\u09be\u0987\u09ae\u09be\u09b0\u09bf \u0995\u09bf; \u0985\u09a8\u09cd\u09af\u09a6\u09bf\u0995\u09c7 &#8221;Orders\u201d \u099f\u09c7\u09ac\u09b2\u09c7\u09b0 &#8220;P_Id\u201d \u0995\u09b2\u09be\u09ae \u09b9\u09b2\u09cb &#8221;Orders\u201d \u099f\u09c7\u09ac\u09b2\u09c7\u09b0 \u09ab\u09b0\u09c7\u09a8 \u0995\u09bf\u0964<br \/>\n\u0995\u09bf\u099b\u09c1 \u0995\u09bf\u099b\u09c1 \u0995\u09be\u09b0\u09cd\u09af\u0995\u09cd\u09b0\u09ae, \u09af\u09c7\u0997\u09c1\u09b2\u09cb \u099f\u09c7\u09ac\u09b2 \u09a5\u09c7\u0995\u09c7 \u099f\u09c7\u09ac\u09b2\u09c7\u09b0 \u09af\u09c7 \u09b2\u09bf\u0982\u0995 \u09b0\u09df\u09c7\u099b\u09c7 \u09a4\u09be \u09a8\u09b7\u09cd\u099f \u0995\u09b0\u09c7 \u09a6\u09bf\u09a4\u09c7 \u09aa\u09be\u09b0\u09c7, \u09ac\u09a8\u09cd\u09a7 \u0995\u09b0\u09be\u09b0 \u099c\u09a8\u09cd\u09af FOREIGHN KEY \u09ac\u09cd\u09af\u09ac\u09b9\u09c3\u09a4 \u09b9\u09df\u0964 FOREIGHN KEY \u0995\u09a8\u09cd\u09b8\u099f\u09cd\u09b0\u09c7\u0987\u09a8\u09cd\u099f \u09ab\u09b0\u09c7\u09a8 \u0995\u09bf \u0995\u09b2\u09be\u09ae\u09c7 \u09ad\u09c1\u09b2 \u09ac\u09be \u0987\u09a8\u09ad\u09cd\u09af\u09be\u09b2\u09bf\u09a1 \u09a1\u09be\u099f\u09be \u09aa\u09cd\u09b0\u09ac\u09c7\u09b6 \u0995\u09b0\u09be\u09a8\u09cb\u09b0 \u0995\u09cd\u09b7\u09c7\u09a4\u09cd\u09b0\u09c7\u0993 \u09ac\u09be\u09a7\u09be \u09a6\u09c7\u09df \u0995\u09be\u09b0\u09a8 \u098f\u099f\u09bf \u09b6\u09c1\u09a7\u09c1\u09ae\u09be\u09a4\u09cd\u09b0 \u09b8\u09c7\u0987 \u09ad\u09cd\u09af\u09be\u09b2\u09c1\u0997\u09c1\u09b2\u09cb \u09a7\u09be\u09b0\u09a3 \u0995\u09b0\u09a4\u09c7 \u09aa\u09be\u09b0\u09ac\u09c7 \u09af\u09be \u0985\u09a8\u09cd\u09af \u099f\u09c7\u09ac\u09b2\u09c7\u09b0 \u09aa\u09cd\u09b0\u09be\u0987\u09ae\u09be\u09b0\u09bf \u0995\u09bf \u0995\u09b2\u09be\u09ae\u09c7 \u09b8\u0982\u09b0\u0995\u09cd\u09b7\u09bf\u09a4 \u09b0\u09df\u09c7\u099b\u09c7\u0964<\/p>\n<p>CREATE TABLE \u098f \u098f\u09b8\u0995\u09bf\u0989\u098f\u09b2 FOREIGHN KEY \u0995\u09a8\u09cd\u09b8\u099f\u09cd\u09b0\u09c7\u0987\u09a8\u09cd\u099f<br \/>\n\u09a8\u09bf\u099a\u09c7\u09b0 \u098f\u09b8\u0995\u09bf\u0989\u098f\u09b2 \u09b8\u09bf\u09a8\u09cd\u099f\u09c7\u0995\u09cd\u09b8\u099f\u099f\u09bf &#8221;Orders\u201d \u099f\u09c7\u09ac\u09b2 \u09a4\u09c8\u09b0\u09bf \u0995\u09b0\u09be\u09b0 \u09b8\u09ae\u09df \u09a4\u09be\u09b0 &#8220;P_Id\u201d \u0995\u09b2\u09be\u09ae\u09c7 \u098f\u0995\u099f\u09bf FOREIGHN KEY \u09a4\u09c8\u09b0\u09bf \u0995\u09b0\u09c7; \u09ac\u09bf\u09ad\u09bf\u09a8\u09cd\u09a8 \u09a1\u09be\u099f\u09be\u09ac\u09c7\u099c \u09b8\u09bf\u09b8\u09cd\u099f\u09c7\u09ae\u09c7 \u09ab\u09b0\u09c7\u09a8 \u0995\u09bf&#8217;\u09b0 \u098f\u09b8\u0995\u09bf\u0989\u098f\u09b2\u0997\u09c1\u09b2\u09cb \u09a6\u09c7\u0996\u09c7 \u09a8\u09c7\u09df\u09be \u09af\u09be\u0995\u0983<br \/>\nMySQL:<br \/>\nCREATE TABLE Orders<br \/>\n(<br \/>\nO_Id int NOT NULL,<br \/>\nOrderNo int NOT NULL,<br \/>\nP_Id int,<br \/>\nPRIMARY KEY (O_Id),<br \/>\nFOREIGN KEY (P_Id) REFERENCES Persons(P_Id)<br \/>\n)<br \/>\nSQL Server \/ Oracle \/ MS Access:<br \/>\nCREATE TABLE Orders<br \/>\n(<br \/>\nO_Id int NOT NULL PRIMARY KEY,<br \/>\nOrderNo int NOT NULL,<br \/>\nP_Id int FOREIGN KEY REFERENCES Persons(P_Id)<br \/>\n)<\/p>\n<p>FOREIGHN KEY \u0995\u09a8\u09cd\u09b8\u099f\u09cd\u09b0\u09c7\u0987\u09a8\u09cd\u099f\u09c7\u09b0 \u09a8\u09be\u09ae\u0995\u09b0\u09a8 \u0995\u09b0\u09be\u09b0 \u099c\u09a8\u09cd\u09af \u098f\u09ac\u0982 \u0985\u09a8\u09c7\u0995\u0997\u09c1\u09b2\u09cb \u0995\u09b2\u09be\u09ae\u09c7 \u098f\u0995\u099f\u09bf FOREIGHN KEY \u0995\u09a8\u09cd\u09b8\u099f\u09cd\u09b0\u09c7\u0987\u09a8\u09cd\u099f \u09b8\u0982\u099c\u09cd\u099e\u09be\u09df\u09bf\u09a4 \u0995\u09b0\u09be\u09b0 \u099c\u09a8\u09cd\u09af \u09a8\u09bf\u099a\u09c7\u09b0 \u098f\u09b8\u0995\u09bf\u0989\u098f\u09b2 \u09b8\u09bf\u09a8\u09cd\u099f\u09c7\u0995\u09cd\u09b8\u099f \u09ac\u09cd\u09af\u09ac\u09b9\u09be\u09b0 \u0995\u09b0\u09c1\u09a8\u0983<br \/>\nMySQL \/ SQL Server \/ Oracle \/ MS Access:<br \/>\nCREATE TABLE Orders<br \/>\n(<br \/>\nO_Id int NOT NULL,<br \/>\nOrderNo int NOT NULL,<br \/>\nP_Id int,<br \/>\nPRIMARY KEY (O_Id),<br \/>\nCONSTRAINT fk_PerOrders FOREIGN KEY (P_Id)<br \/>\nREFERENCES Persons(P_Id)<br \/>\n)<\/p>\n<p>ALTER TABLE \u098f \u098f\u09b8\u0995\u09bf\u0989\u098f\u09b2 FOREIGHN KEY \u0995\u09a8\u09cd\u09b8\u099f\u09cd\u09b0\u09c7\u0987\u09a8\u09cd\u099f<br \/>\n\u09af\u09c7\u0996\u09be\u09a8\u09c7 &#8220;Orders\u201d \u099f\u09c7\u09ac\u09b2\u099f\u09bf \u0987\u09a4\u09cb\u09ae\u09a7\u09cd\u09af\u09c7\u0987 \u09a4\u09c8\u09b0\u09bf \u0995\u09b0\u09be \u09b9\u09df\u09c7 \u0997\u09c7\u099b\u09c7 \u09b8\u09c7\u0995\u09cd\u09b7\u09c7\u09a4\u09cd\u09b0\u09c7 &#8220;Orders\u201d \u099f\u09c7\u09ac\u09b2\u09c7\u09b0 &#8216;\u201dP_Id\u201d \u0995\u09b2\u09be\u09ae\u09c7 \u098f\u0995\u099f\u09bf FOREIGHN KEY\u201d \u0995\u09a8\u09cd\u09b8\u099f\u09cd\u09b0\u09c7\u0987\u09a8\u09cd\u099f \u09a4\u09c8\u09b0\u09bf \u0995\u09b0\u09a4\u09c7 \u09a8\u09bf\u099a\u09c7\u09b0 \u098f\u09b8\u0995\u09bf\u0989\u098f\u09b2&#8217;\u099f\u09bf \u09ac\u09cd\u09af\u09ac\u09b9\u09be\u09b0 \u0995\u09b0\u09c1\u09a8\u0983<br \/>\nMySQL \/ SQL Server \/ Oracle \/ MS Access:<br \/>\nALTER TABLE Orders<br \/>\nADD FOREIGN KEY (P_Id)<br \/>\nREFERENCES Persons(P_Id)<\/p>\n<p>\u09ab\u09b0\u09c7\u09a8 \u0995\u09bf \u0995\u09a8\u09cd\u09b8\u099f\u09cd\u09b0\u09c7\u0987\u09a8\u09cd\u099f\u09c7\u09b0 \u09a8\u09be\u09ae\u0995\u09b0\u09a8 \u0995\u09b0\u09be\u09b0 \u099c\u09a8\u09cd\u09af \u098f\u09ac\u0982 \u0985\u09a8\u09c7\u0995\u0997\u09c1\u09b2\u09cb \u0995\u09b2\u09be\u09ae\u09c7 \u098f\u0995\u099f\u09bf \u09ab\u09b0\u09c7\u09a8 \u0995\u09bf \u0995\u09a8\u09cd\u09b8\u099f\u09cd\u09b0\u09c7\u0987\u09a8\u09cd\u099f \u09b8\u0982\u099c\u09cd\u099e\u09be\u09df\u09bf\u09a4 \u0995\u09b0\u09be\u09b0 \u099c\u09a8\u09cd\u09af(ALTER TABLE \u098f\u09b0 \u0995\u09cd\u09b7\u09c7\u09a4\u09cd\u09b0\u09c7) \u09a8\u09bf\u099a\u09c7\u09b0 \u098f\u09b8\u0995\u09bf\u0989\u098f\u09b2 \u09b8\u09bf\u09a8\u09cd\u099f\u09cd\u09af\u09be\u0995\u09cd\u09b8\u099f \u09ac\u09cd\u09af\u09ac\u09b9\u09be\u09b0 \u0995\u09b0\u09c1\u09a8\u0983<br \/>\nMySQL \/ SQL Server \/ Oracle \/ MS Access:<br \/>\nALTER TABLE Orders<br \/>\nADD CONSTRAINT fk_PerOrders<br \/>\nFOREIGN KEY (P_Id)<br \/>\nREFERENCES Persons(P_Id)<\/p>\n<p>\u098f\u0995\u099f\u09bf \u09ab\u09b0\u09c7\u09a8 \u0995\u09bf \u0995\u09a8\u09cd\u09b8\u099f\u09cd\u09b0\u09c7\u0987\u09a8\u09cd\u099f \u09a1\u09cd\u09b0\u09aa \u0995\u09b0\u09be\u09b0 \u099c\u09a8\u09cd\u09af<br \/>\n\u098f\u0995\u099f\u09bf FOREIGHN KEY \u0995\u09a8\u09cd\u09b8\u099f\u09cd\u09b0\u09c7\u0987\u09a8\u09cd\u099f DROP \u0985\u09b0\u09cd\u09a5\u09be\u09ce \u09b8\u09c7\u099f\u09bf \u09ac\u09be\u09a6 \u09a6\u09c7\u09df\u09be\u09b0 \u099c\u09a8\u09cd\u09af \u09a8\u09bf\u099a\u09c7\u09b0 \u098f\u09b8\u0995\u09bf\u0989\u098f\u09b2&#8217;\u099f\u09bf \u09ac\u09cd\u09af\u09ac\u09b9\u09be\u09b0 \u0995\u09b0\u09c1\u09a8\u0983<br \/>\nMySQL:<br \/>\nALTER TABLE Orders<br \/>\nDROP FOREIGN KEY fk_PerOrders<br \/>\nSQL Server \/ Oracle \/ MS Access:<br \/>\nALTER TABLE Orders<br \/>\nDROP CONSTRAINT fk_PerOrders<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u098f\u09b8\u0995\u09bf\u0989\u098f\u09b2 \u09ab\u09b0\u09c7\u09a8 \u0995\u09bf \u0995\u09a8\u09cd\u09b8\u099f\u09cd\u09b0\u09c7\u0987\u09a8\u09cd\u099f Sheikh Mahfuzur Rahman \u098f\u0995\u099f\u09bf \u099f\u09c7\u09ac\u09b2\u09c7\u09b0 FOREIGHN KEY \u0985\u09a8\u09cd\u09af \u099f\u09c7\u09ac\u09b2\u09c7\u09b0 PRIMARY KEY \u098f\u09b0 \u09a6\u09bf\u0995\u09c7 \u09a8\u09bf\u09b0\u09cd\u09a6\u09c7\u09b6 \u0995\u09b0\u09c7\u0964 \u098f\u0995\u099f\u09bf \u0989\u09a6\u09be\u09b9\u09b0\u09a3\u09c7\u09b0 \u09ae\u09be\u09a7\u09cd\u09af\u09ae\u09c7 &#8220;\u09ab\u09b0\u09c7\u09a8 \u0995\u09bf&#8221; \u0995\u09c7 \u09ac\u09cd\u09af\u09be\u0996\u09cd\u09af\u09be \u0995\u09b0\u09be \u09af\u09be\u0995\u0964 \u09a8\u09bf\u099a\u09c7\u09b0 \u09a6\u09c1\u099f\u09cb \u099f\u09c7\u09ac\u09b2\u09c7\u09b0 \u09a6\u09bf\u0995\u09c7 \u09b2\u0995\u09cd\u09b7\u09cd\u09af \u0995\u09b0\u09c1\u09a8 \u09af\u09be\u09b0 \u098f\u0995\u099f\u09bf \u09b9\u09b2\u09cb &#8221;Persons&#8221; \u099f\u09c7\u09ac\u09b2 \u098f\u09ac\u0982 \u0985\u09a8\u09cd\u09af\u099f\u09bf \u09b9\u09b2\u09cb &#8220;Orders\u201d \u099f\u09c7\u09ac\u09b2\u0983 The &#8220;Persons&#8221; table: P_Id LastName FirstName Address City 1 Hansen Ola &hellip; <\/p>\n<p><a class=\"more-link btn\" href=\"http:\/\/bangla.sitestree.com\/?p=5953\">Continue reading<\/a><\/p>\n","protected":false},"author":8,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[155],"tags":[],"class_list":["post-5953","post","type-post","status-publish","format-standard","hentry","category------sql-001","item-wrap"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":5945,"url":"http:\/\/bangla.sitestree.com\/?p=5945","url_meta":{"origin":5953,"position":0},"title":"\u098f\u09b8\u0995\u09bf\u0989\u098f\u09b2 \u0995\u09a8\u09cd\u09b8\u099f\u09cd\u09b0\u09c7\u0987\u09a8\u09cd\u099f\u09b8 .  SQL Constraints","author":"Author-Check- Article-or-Video","date":"January 30, 2015","format":false,"excerpt":"Sheikh Mahfuzur Rahman Blogger @ BloggersEcho.Com Bengali Word Count: 155-159 \u098f\u09b8\u0995\u09bf\u0989\u098f\u09b2 \u0995\u09a8\u09cd\u09b8\u099f\u09cd\u09b0\u09c7\u0987\u09a8\u09cd\u099f\u09b8 \u0993\u09df\u09c7\u09ac \u09a1\u09be\u099f\u09be\u09ac\u09c7\u099c \u09b2\u09cd\u09af\u09be\u0999\u09cd\u0997\u09c1\u09df\u09c7\u099c \u098f\u09b8\u0995\u09bf\u0989\u098f\u09b2(SQL) \u098f \u0995\u09a8\u09cd\u09b8\u099f\u09cd\u09b0\u09c7\u0987\u09a8\u09cd\u099f\u0997\u09c1\u09b2\u09cb(Constraints) \u0995\u09cb\u09a8 \u099f\u09c7\u09ac\u09b2\u09c7\u09b0 \u09a1\u09be\u099f\u09be\u0997\u09c1\u09b2\u09cb\u09b0 \u09b0\u09c1\u09b2\u09b8 \u09ac\u09be \u09a8\u09c0\u09a4\u09bf \u09a8\u09bf\u09b0\u09cd\u09a7\u09be\u09b0\u09a3\u09c7 \u09ac\u09cd\u09af\u09ac\u09b9\u09c3\u09a4 \u09b9\u09df\u0964 \u098f\u0995\u09cd\u09b7\u09c7\u09a4\u09cd\u09b0\u09c7 \u09a1\u09be\u099f\u09be \u0985\u09cd\u09af\u09be\u0995\u09b6\u09be\u09a8 \u098f\u09ac\u0982 \u0995\u09a8\u09cd\u09b8\u099f\u09cd\u09b0\u09c7\u0987\u09a8\u09cd\u099f\u09c7\u09b0 \u09a8\u09c0\u09a4\u09bf\u09b0 \u09ae\u09a7\u09cd\u09af\u09c7 \u09b8\u09be\u0982\u0998\u09b0\u09cd\u09b7\u09bf\u0995(Violation) \u0995\u09bf\u099b\u09c1 \u0998\u099f\u09b2\u09c7 \u0995\u09a8\u09cd\u09b8\u099f\u09cd\u09b0\u09c7\u0987\u09a8\u09cd\u099f\u09c7\u09b0 \u0995\u09be\u09b0\u09cd\u09af\u0995\u09be\u09b0\u09bf\u09a4\u09be \u09ac\u09be\u09a4\u09bf\u09b2 \u09b9\u09df\u09c7 \u09af\u09be\u09df\u0964 \u09af\u0996\u09a8 \u099f\u09c7\u09ac\u09b2 \u09a4\u09c8\u09b0\u09bf \u0995\u09b0\u09be \u09b9\u09df \u09a4\u0996\u09a8 CREATE TABLE\u2026","rel":"","context":"In &quot;\u098f\u09b8 \u0995\u09bf\u0989 \u098f\u09b2 - \u09e6\u09e6\u09e7 \u0964 SQL - 001&quot;","block_context":{"text":"\u098f\u09b8 \u0995\u09bf\u0989 \u098f\u09b2 - \u09e6\u09e6\u09e7 \u0964 SQL - 001","link":"http:\/\/bangla.sitestree.com\/?cat=155"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":5955,"url":"http:\/\/bangla.sitestree.com\/?p=5955","url_meta":{"origin":5953,"position":1},"title":"\u098f\u09b8\u0995\u09bf\u0989\u098f\u09b2 \u099a\u09c7\u0995 \u0995\u09a8\u09cd\u09b8\u099f\u09cd\u09b0\u09c7\u0987\u09a8\u09cd\u099f. SQL Check Constraint","author":"Author-Check- Article-or-Video","date":"January 30, 2015","format":false,"excerpt":"\u098f\u09b8\u0995\u09bf\u0989\u098f\u09b2 \u099a\u09c7\u0995 \u0995\u09a8\u09cd\u09b8\u099f\u09cd\u09b0\u09c7\u0987\u09a8\u09cd\u099f \u098f\u09b8\u0995\u09bf\u0989\u098f\u09b2(SQL) \u0995\u09a8\u09b8\u09cd\u099f\u09cd\u09b0\u09c7\u0987\u09a8\u09cd\u099f\u0997\u09c1\u09b2\u09cb\u09b0(Constraint) \u09ae\u09a7\u09cd\u09af\u09c7 \u0985\u09a8\u09cd\u09af\u09a4\u09ae \u09b9\u09b2\u09cb CHECK \u0995\u09a8\u09cd\u09b8\u099f\u09cd\u09b0\u09c7\u0987\u09a8\u09cd\u099f\u0964 CHECK \u0995\u09a8\u09cd\u09b8\u099f\u09cd\u09b0\u09c7\u0987\u09a8\u09cd\u099f \u098f\u0995\u099f\u09bf \u0995\u09b2\u09be\u09ae\u09c7 \u09b0\u09be\u0996\u09be\u09b0 \u09ae\u09a4\u09cb \u09ad\u09cd\u09af\u09be\u09b2\u09c1 \u09b0\u09c7\u099e\u09cd\u099c\u0995\u09c7 \u09b8\u09c0\u09ae\u09bf\u09a4 \u0995\u09b0\u09c7 \u09a6\u09c7\u09df\u09be\u09b0 \u099c\u09a8\u09cd\u09af \u09ac\u09cd\u09af\u09ac\u09b9\u09c3\u09a4 \u09b9\u09df\u0964 \u09af\u09a6\u09bf \u0986\u09aa\u09a8\u09bf \u098f\u0995\u099f\u09bf \u0995\u09b2\u09be\u09ae\u09c7 CHECK \u0995\u09a8\u09cd\u09b8\u099f\u09cd\u09b0\u09c7\u0987\u09a8\u09cd\u099f \u09b8\u0982\u099c\u09cd\u099e\u09be\u09df\u09bf\u09a4 \u0995\u09b0\u09c7 \u09a6\u09c7\u09a8 \u09a4\u09be\u09b9\u09b2\u09c7 \u0990 \u0995\u09b2\u09be\u09ae \u09b6\u09c1\u09a7\u09c1\u09ae\u09be\u09a4\u09cd\u09b0 \u09a8\u09bf\u09b0\u09cd\u09a6\u09bf\u09b7\u09cd\u099f \u0995\u09a4\u0997\u09c1\u09b2\u09cb \u09ad\u09cd\u09af\u09be\u09b2\u09c1 \u0997\u09cd\u09b0\u09b9\u09a8 \u0995\u09b0\u09a4\u09c7 \u09aa\u09be\u09b0\u09ac\u09c7\u0964 \u09af\u09a6\u09bf \u098f\u0995\u099f\u09bf \u099f\u09c7\u09ac\u09b2\u09c7 CHECK \u0995\u09a8\u09cd\u09b8\u099f\u09cd\u09b0\u09c7\u0987\u09a8\u09cd\u099f \u09b8\u0982\u099c\u09cd\u099e\u09be\u09df\u09bf\u09a4 \u0995\u09b0\u09c7\u2026","rel":"","context":"In &quot;\u098f\u09b8 \u0995\u09bf\u0989 \u098f\u09b2 - \u09e6\u09e6\u09e7 \u0964 SQL - 001&quot;","block_context":{"text":"\u098f\u09b8 \u0995\u09bf\u0989 \u098f\u09b2 - \u09e6\u09e6\u09e7 \u0964 SQL - 001","link":"http:\/\/bangla.sitestree.com\/?cat=155"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":5933,"url":"http:\/\/bangla.sitestree.com\/?p=5933","url_meta":{"origin":5953,"position":2},"title":"SQL (\u098f\u09b8\u0995\u09bf\u0989\u098f\u09b2) FOREIGN KEY \u0995\u09a8\u09b8\u09cd\u099f\u09cd\u09b0\u09c7\u0987\u09a8\u09cd\u099f\u09b8\u09cd. SQL Foreign Key Constraint","author":"Author-Check- Article-or-Video","date":"January 30, 2015","format":false,"excerpt":"SQL (\u098f\u09b8\u0995\u09bf\u0989\u098f\u09b2) FOREIGN KEY \u0995\u09a8\u09b8\u09cd\u099f\u09cd\u09b0\u09c7\u0987\u09a8\u09cd\u099f\u09b8\u09cd Article By: Protap Chandra FOREIGN KEY \u0995\u09a8\u09b8\u09cd\u099f\u09cd\u09b0\u09c7\u0987\u09a8\u09cd\u099f \u09ac\u09cd\u09af\u09ac\u09b9\u09be\u09b0 \u0995\u09b0\u09be \u09af\u09be\u09df \u099f\u09c7\u09ac\u09bf\u09b2\u0997\u09c1\u09b2\u09cb\u09b0 \u09ae\u09a7\u09cd\u09af\u09c7 \u0986\u09a8\u09cd\u09a4:\u09b8\u0982\u09af\u09cb\u0997 \u09af\u09be\u09a4\u09c7 \u09a8\u09b7\u09cd\u099f \u09a8\u09be \u09b9\u09df \u09a4\u09be \u09a8\u09bf\u09b6\u09cd\u099a\u09bf\u09a4 \u0995\u09b0\u09be\u09b0 \u099c\u09a8\u09cd\u09af\u0964 \u098f\u099b\u09be\u09dc\u09be FOREIGN KEY \u0995\u09a8\u09b8\u09cd\u099f\u09cd\u09b0\u09c7\u0987\u09a8\u09cd\u099f foreign key \u09af\u09c1\u0995\u09cd\u09a4 \u0995\u09b2\u09be\u09ae\u09c7 \u0985\u0997\u09cd\u09b0\u09b9\u09a3\u09af\u09cb\u0997\u09cd\u09af \u09a1\u09be\u099f\u09be \u0987\u09a8\u09aa\u09c1\u099f\u09c7 \u09a6\u09c7\u09df\u09be\u09b0 \u09b9\u09be\u09a4 \u09a5\u09c7\u0995\u09c7\u0993 \u09ac\u09cd\u09af\u09ac\u09b9\u09be\u09b0\u0995\u09be\u09b0\u09c0\u09a6\u09c7\u09b0 \u09ac\u09bf\u09b0\u09a4 \u09b0\u09be\u0996\u09c7\u0964 \u0995\u09be\u09b0\u09a3 FOREIGN KEY \u09b8\u0999\u09cd\u0997\u09be\u09df\u09bf\u09a4 \u0995\u09b2\u09be\u09ae\u09c7 \u0995\u09c7\u09ac\u09b2 \u09b8\u09c7\u0987\u2026","rel":"","context":"In &quot;\u098f\u09b8 \u0995\u09bf\u0989 \u098f\u09b2 - \u09e6\u09e6\u09e7 \u0964 SQL - 001&quot;","block_context":{"text":"\u098f\u09b8 \u0995\u09bf\u0989 \u098f\u09b2 - \u09e6\u09e6\u09e7 \u0964 SQL - 001","link":"http:\/\/bangla.sitestree.com\/?cat=155"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":5910,"url":"http:\/\/bangla.sitestree.com\/?p=5910","url_meta":{"origin":5953,"position":3},"title":"\u098f\u09b8\u0995\u09bf\u0989\u098f\u09b2 \u09ab\u09c1\u09b2 \u0986\u0989\u099f\u09be\u09b0 \u099c\u09df\u09c7\u09a8 \u0995\u09bf\u0993\u09df\u09be\u09b0\u09cd\u09a1 . SQL FULL OUTER JOIN Keyword","author":"Author-Check- Article-or-Video","date":"January 30, 2015","format":false,"excerpt":"\u098f\u09b8\u0995\u09bf\u0989\u098f\u09b2 \u09ab\u09c1\u09b2 \u0986\u0989\u099f\u09be\u09b0 \u099c\u09df\u09c7\u09a8 \u0995\u09bf\u0993\u09df\u09be\u09b0\u09cd\u09a1 Sheikh Mahfuzur Rahman FULL OUTER JOIN \u0995\u09bf\u0993\u09df\u09be\u09b0\u09cd\u09a1 \u09ac\u09be\u09ae \u09a6\u09bf\u0995\u09c7\u09b0 \u099f\u09c7\u09ac\u09b2(table1) \u098f\u09ac\u0982 \u09a1\u09be\u09a8 \u09a6\u09bf\u0995\u09c7\u09b0 \u099f\u09c7\u09ac\u09b2\u09c7\u09b0(table2) \u09b8\u09ac\u0997\u09c1\u09b2\u09cb \u09b8\u09be\u09b0\u09bf\u0995\u09c7 \u09ab\u09c7\u09b0\u09a4 \u09a6\u09c7\u09df\u0964 FULL OUTER JOIN \u0995\u09bf\u0993\u09df\u09be\u09b0\u09cd\u09a1 LEFT \u0993 RIGHT \u0989\u09ad\u09df \u09b8\u0982\u09af\u09cb\u0997-\u09b8\u09cd\u09a5\u09b2\u0995\u09c7\u0987 \u09ae\u09bf\u09b2\u09bf\u09df\u09c7 \u09a6\u09c7\u09df\u0964 \u098f\u09b8\u0995\u09bf\u0989\u098f\u09b2 FULL OUTER JOIN \u09b8\u09bf\u09a8\u09cd\u099f\u09c7\u0995\u09cd\u09b8\u099f\u0983 SELECT column_name(s) FROM table1 FULL OUTER JOIN table2 ON table1.column_name=table2.column_name; \u09a8\u09ae\u09c1\u09a8\u09be\u2026","rel":"","context":"In &quot;\u098f\u09b8 \u0995\u09bf\u0989 \u098f\u09b2 - \u09e6\u09e6\u09e7 \u0964 SQL - 001&quot;","block_context":{"text":"\u098f\u09b8 \u0995\u09bf\u0989 \u098f\u09b2 - \u09e6\u09e6\u09e7 \u0964 SQL - 001","link":"http:\/\/bangla.sitestree.com\/?cat=155"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":6344,"url":"http:\/\/bangla.sitestree.com\/?p=6344","url_meta":{"origin":5953,"position":4},"title":"\u098f\u098f\u09b8\u09aa\u09bf.\u09a8\u09c7\u099f \u098f\u09ae\u09ad\u09bf\u09b8\u09bf &#8211; \u098f\u09b8\u0995\u09bf\u0989\u098f\u09b2 \u09a1\u09be\u099f\u09be\u09ac\u09c7\u099c . ASP.NET MVC &#8211; SQL Database","author":"Author-Check- Article-or-Video","date":"February 22, 2015","format":false,"excerpt":"\u098f\u098f\u09b8\u09aa\u09bf.\u09a8\u09c7\u099f \u098f\u09ae\u09ad\u09bf\u09b8\u09bf - \u098f\u09b8\u0995\u09bf\u0989\u098f\u09b2 \u09a1\u09be\u099f\u09be\u09ac\u09c7\u099c Sheikh Mahfuzur Rahman Bangla word: 300 \u098f\u098f\u09b8\u09aa\u09bf.\u09a8\u09c7\u099f \u098f\u09ae\u09ad\u09bf\u09b8\u09bf (ASP.NET MVC) \u09b6\u09bf\u0996\u09a4\u09c7 \u0997\u09bf\u09df\u09c7 \u0986\u09ae\u09b0\u09be \u098f\u0995\u099f\u09bf \u0987\u09a8\u09cd\u099f\u09be\u09b0\u09a8\u09c7\u099f \u0985\u09cd\u09af\u09be\u09aa\u09cd\u09b2\u09bf\u0995\u09c7\u09b6\u09a8 \u09a4\u09c8\u09b0\u09bf \u0995\u09b0\u099b\u09bf\u0964 \u0986\u099c\u0995\u09c7 \u09af\u09be\u09b0 \u09b7\u09b7\u09cd\u099f \u09aa\u09be\u09b0\u09cd\u099f \u09a8\u09bf\u09df\u09c7 \u0986\u09b2\u099a\u09cb\u09a8\u09be \u0995\u09b0\u09be \u09b9\u09ac\u09c7\u0964 \u09aa\u09c2\u09b0\u09cd\u09ac\u09c7\u09b0 \u09aa\u09be\u09b0\u09cd\u099f\u0997\u09c1\u09b2\u09cb \u09aa\u09dc\u09c7 \u09a8\u09be \u09a5\u09be\u0995\u09b2\u09c7 \u09aa\u09cd\u09b0\u09a5\u09ae\u09c7 \u09aa\u09dc\u09c7 \u09a8\u09bf\u09a8\u0964 \u09b7\u09b7\u09cd\u099f \u09aa\u09be\u09b0\u09cd\u099f\u0983 \u09a1\u09be\u099f\u09be\u09ac\u09c7\u099c \u09af\u09cb\u0997 \u0995\u09b0\u09be \u09a1\u09be\u099f\u09be\u09ac\u09c7\u099c\u099f\u09bf \u09a4\u09c8\u09b0\u09bf \u0995\u09b0\u09be \u09ad\u09bf\u099c\u09cd\u09af\u09c1\u09df\u09be\u09b2 \u0993\u09df\u09c7\u09ac \u09a1\u09c7\u09ad\u09b2\u09be\u09aa\u09be\u09b0\u09c7\u2026","rel":"","context":"In &quot;\u098f \u098f\u09b8 \u09aa\u09bf . \u09a8\u09c7\u099f \u098f\u09ae \u09ad\u09bf \u09b8\u09bf \u0964 ASP.Net MVC&quot;","block_context":{"text":"\u098f \u098f\u09b8 \u09aa\u09bf . \u09a8\u09c7\u099f \u098f\u09ae \u09ad\u09bf \u09b8\u09bf \u0964 ASP.Net MVC","link":"http:\/\/bangla.sitestree.com\/?cat=180"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":5949,"url":"http:\/\/bangla.sitestree.com\/?p=5949","url_meta":{"origin":5953,"position":5},"title":"SQL \u0987\u0989\u09a8\u09bf\u0995 Constraint  . SQL Unique Constraint","author":"Author-Check- Article-or-Video","date":"January 30, 2015","format":false,"excerpt":"SQL \u0987\u0989\u09a8\u09bf\u0995 Constraint RIAZ-UL-HAQUE MIAN \u0987\u0989\u09a8\u09bf\u0995 Constraint \u098f\u0995\u099f\u09bf \u099f\u09c7\u09ac\u09bf\u09b2 \u098f\u09b0 \u09af\u09c7\u0995\u09cb\u09a8\u09cb \u098f\u0995\u099f\u09bf \u0995\u09b2\u09be\u09ae \u098f\u09b0 \u09b8\u09cd\u09ac\u09a4\u09a8\u09cd\u09a4\u09cd\u09b0\u09a4\u09be\/ uniqueness \u0995\u09c7 \u09ac\u09c1\u099d\u09be\u09df . \u099f\u09c7\u09ac\u09bf\u09b2 \u098f\u09b0 \u09aa\u09cd\u09b0\u09be\u0987\u09ae\u09be\u09b0\u09bf \u0995\u09bf \u09b8\u09c7\u099f \u0995\u09b0\u09b2\u09c7 \u09a4\u09be automatically \u0987\u0989\u09a8\u09bf\u0995 Constraint \u09b9\u09df\u09c7 \u09af\u09be\u09df\u0964 \u09a4\u09be\u09b9\u09b2\u09c7 \u09aa\u09cd\u09b0\u09b6\u09cd\u09a8 \u09b9\u09b2\u09cb \u0987\u0989\u09a8\u09bf\u0995 Constraint \u09a6\u09b0\u0995\u09be\u09b0 \u0995\u09bf ? \u0995\u09be\u09b0\u09a3 \u0986\u09aa\u09a8\u09bf \u098f\u0995\u099f\u09be \u099f\u09c7\u09ac\u09bf\u09b2 \u098f\u09b0 \u098f\u0995\u099f\u09be \u09ae\u09be\u09a4\u09cd\u09b0 \u0995\u09b2\u09be\u09ae \u0995\u09c7 \u0987 \u09aa\u09cd\u09b0\u09be\u0987\u09ae\u09be\u09b0\u09bf\u2026","rel":"","context":"In &quot;\u098f\u09b8 \u0995\u09bf\u0989 \u098f\u09b2 - \u09e6\u09e6\u09e7 \u0964 SQL - 001&quot;","block_context":{"text":"\u098f\u09b8 \u0995\u09bf\u0989 \u098f\u09b2 - \u09e6\u09e6\u09e7 \u0964 SQL - 001","link":"http:\/\/bangla.sitestree.com\/?cat=155"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/5953","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/users\/8"}],"replies":[{"embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=5953"}],"version-history":[{"count":1,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/5953\/revisions"}],"predecessor-version":[{"id":5954,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/5953\/revisions\/5954"}],"wp:attachment":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=5953"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=5953"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=5953"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}