{"id":74,"date":"2009-09-01T13:19:00","date_gmt":"1970-01-01T00:00:00","guid":{"rendered":"http:\/\/www.yazilimmutfagi.com\/?p=74"},"modified":"2009-09-01T13:19:00","modified_gmt":"1970-01-01T00:00:00","slug":"t-sql-e-genel-bakis-3","status":"publish","type":"post","link":"https:\/\/www.yazilimmutfagi.com\/index.php\/2009\/09\/01\/t-sql-e-genel-bakis-3\/","title":{"rendered":"T-SQL \u2018e Genel Bakis \/ 3"},"content":{"rendered":"<p>\n<meta content=\"text\/html; charset=utf-8\" http-equiv=\"Content-Type\" \/>\n<meta content=\"Word.Document\" name=\"ProgId\" \/>\n<meta content=\"Microsoft Word 12\" name=\"Generator\" \/>\n<meta content=\"Microsoft Word 12\" name=\"Originator\" \/>\n<link href=\"file:\/\/\/C:\\Users\\msk\\AppData\\Local\\Temp\\msohtmlclip1\\01\\clip_filelist.xml\" rel=\"File-List\" \/>\n<link href=\"file:\/\/\/C:\\Users\\msk\\AppData\\Local\\Temp\\msohtmlclip1\\01\\clip_themedata.thmx\" rel=\"themeData\" \/>\n<link href=\"file:\/\/\/C:\\Users\\msk\\AppData\\Local\\Temp\\msohtmlclip1\\01\\clip_colorschememapping.xml\" rel=\"colorSchemeMapping\" \/><!--[if gte mso 9]><xml>\n<w:LatentStyles DefLockedState=\"false\" DefUnhideWhenUsed=\"true\"\nDefSemiHidden=\"true\" DefQFormat=\"false\" DefPriority=\"99\"\nLatentStyleCount=\"267\">\n<w:LsdException Locked=\"false\" Priority=\"0\" SemiHidden=\"false\"\nUnhideWhenUsed=\"false\" QFormat=\"true\" Name=\"Normal\" \/>\n<w:LsdException Locked=\"false\" Priority=\"9\" SemiHidden=\"false\"\nUnhideWhenUsed=\"false\" QFormat=\"true\" Name=\"heading 1\" \/>\n<w:LsdException Locked=\"false\" Priority=\"9\" QFormat=\"true\" Name=\"heading 2\" \/>\n<w:LsdException Locked=\"false\" Priority=\"9\" QFormat=\"true\" Name=\"heading 3\" \/>\n<w:LsdException Locked=\"false\" Priority=\"9\" QFormat=\"true\" Name=\"heading 4\" \/>\n<w:LsdException Locked=\"false\" Priority=\"9\" QFormat=\"true\" Name=\"heading 5\" \/>\n<w:LsdException Locked=\"false\" Priority=\"9\" QFormat=\"true\" Name=\"heading 6\" \/>\n<w:LsdException Locked=\"false\" Priority=\"9\" QFormat=\"true\" Name=\"heading 7\" \/>\n<w:LsdException Locked=\"false\" Priority=\"9\" QFormat=\"true\" Name=\"heading 8\" \/>\n<w:LsdException Locked=\"false\" Priority=\"9\" QFormat=\"true\" Name=\"heading 9\" \/>\n<w:LsdException Locked=\"false\" Priority=\"39\" Name=\"toc 1\" \/>\n<w:LsdException Locked=\"false\" Priority=\"39\" Name=\"toc 2\" \/>\n<w:LsdException Locked=\"false\" Priority=\"39\" Name=\"toc 3\" \/>\n<w:LsdException Locked=\"false\" Priority=\"39\" Name=\"toc 4\" \/>\n<w:LsdException Locked=\"false\" Priority=\"39\" Name=\"toc 5\" \/>\n<w:LsdException Locked=\"false\" Priority=\"39\" Name=\"toc 6\" \/>\n<w:LsdException Locked=\"false\" Priority=\"39\" Name=\"toc 7\" \/>\n<w:LsdException Locked=\"false\" Priority=\"39\" Name=\"toc 8\" \/>\n<w:LsdException Locked=\"false\" Priority=\"39\" Name=\"toc 9\" \/>\n<w:LsdException Locked=\"false\" Priority=\"35\" QFormat=\"true\" Name=\"caption\" \/>\n<w:LsdException Locked=\"false\" Priority=\"10\" SemiHidden=\"false\"\nUnhideWhenUsed=\"false\" QFormat=\"true\" Name=\"Title\" \/>\n<w:LsdException Locked=\"false\" Priority=\"1\" Name=\"Default Paragraph Font\" \/>\n<w:LsdException Locked=\"false\" Priority=\"11\" SemiHidden=\"false\"\nUnhideWhenUsed=\"false\" QFormat=\"true\" Name=\"Subtitle\" \/>\n<w:LsdException Locked=\"false\" Priority=\"22\" SemiHidden=\"false\"\nUnhideWhenUsed=\"false\" QFormat=\"true\" Name=\"Strong\" \/>\n<w:LsdException Locked=\"false\" Priority=\"20\" SemiHidden=\"false\"\nUnhideWhenUsed=\"false\" QFormat=\"true\" Name=\"Emphasis\" \/>\n<w:LsdException Locked=\"false\" Priority=\"59\" SemiHidden=\"false\"\nUnhideWhenUsed=\"false\" Name=\"Table Grid\" \/>\n<w:LsdException Locked=\"false\" UnhideWhenUsed=\"false\" Name=\"Placeholder Text\" \/>\n<w:LsdException Locked=\"false\" Priority=\"1\" SemiHidden=\"false\"\nUnhideWhenUsed=\"false\" QFormat=\"true\" Name=\"No Spacing\" \/>\n<w:LsdException Locked=\"false\" Priority=\"60\" SemiHidden=\"false\"\nUnhideWhenUsed=\"false\" Name=\"Light Shading\" \/>\n<w:LsdException Locked=\"false\" Priority=\"61\" SemiHidden=\"false\"\nUnhideWhenUsed=\"false\" Name=\"Light List\" \/>\n<w:LsdException Locked=\"false\" Priority=\"62\" SemiHidden=\"false\"\nUnhideWhenUsed=\"false\" Name=\"Light Grid\" \/>\n<w:LsdException Locked=\"false\" Priority=\"63\" SemiHidden=\"false\"\nUnhideWhenUsed=\"false\" Name=\"Medium Shading 1\" \/>\n<w:LsdException Locked=\"false\" Priority=\"64\" SemiHidden=\"false\"\nUnhideWhenUsed=\"false\" Name=\"Medium Shading 2\" \/>\n<w:LsdException Locked=\"false\" Priority=\"65\" SemiHidden=\"false\"\nUnhideWhenUsed=\"false\" Name=\"Medium List 1\" \/>\n<w:LsdException Locked=\"false\" Priority=\"66\" SemiHidden=\"false\"\nUnhideWhenUsed=\"false\" Name=\"Medium List 2\" \/>\n<w:LsdException Locked=\"false\" Priority=\"67\" SemiHidden=\"false\"\nUnhideWhenUsed=\"false\" Name=\"Medium Grid 1\" \/>\n<w:LsdException Locked=\"false\" Priority=\"68\" SemiHidden=\"false\"\nUnhideWhenUsed=\"false\" Name=\"Medium Grid 2\" \/>\n<w:LsdException Locked=\"false\" Priority=\"69\" SemiHidden=\"false\"\nUnhideWhenUsed=\"false\" Name=\"Medium Grid 3\" \/>\n<w:LsdException Locked=\"false\" Priority=\"70\" SemiHidden=\"false\"\nUnhideWhenUsed=\"false\" Name=\"Dark List\" \/>\n<w:LsdException Locked=\"false\" Priority=\"71\" SemiHidden=\"false\"\nUnhideWhenUsed=\"false\" Name=\"Colorful Shading\" \/>\n<w:LsdException Locked=\"false\" Priority=\"72\" SemiHidden=\"false\"\nUnhideWhenUsed=\"false\" Name=\"Colorful List\" \/>\n<w:LsdException Locked=\"false\" Priority=\"73\" SemiHidden=\"false\"\nUnhideWhenUsed=\"false\" Name=\"Colorful Grid\" \/>\n<w:LsdException Locked=\"false\" Priority=\"60\" SemiHidden=\"false\"\nUnhideWhenUsed=\"false\" Name=\"Light Shading Accent 1\" \/>\n<w:LsdException Locked=\"false\" Priority=\"61\" SemiHidden=\"false\"\nUnhideWhenUsed=\"false\" Name=\"Light List Accent 1\" \/>\n<w:LsdException Locked=\"false\" Priority=\"62\" SemiHidden=\"false\"\nUnhideWhenUsed=\"false\" Name=\"Light Grid Accent 1\" \/>\n<w:LsdException Locked=\"false\" Priority=\"63\" SemiHidden=\"false\"\nUnhideWhenUsed=\"false\" Name=\"Medium Shading 1 Accent 1\" \/>\n<w:LsdException Locked=\"false\" Priority=\"64\" SemiHidden=\"false\"\nUnhideWhenUsed=\"false\" Name=\"Medium Shading 2 Accent 1\" \/>\n<w:LsdException Locked=\"false\" Priority=\"65\" SemiHidden=\"false\"\nUnhideWhenUsed=\"false\" Name=\"Medium List 1 Accent 1\" \/>\n<w:LsdException Locked=\"false\" UnhideWhenUsed=\"false\" Name=\"Revision\" \/>\n<w:LsdException Locked=\"false\" Priority=\"34\" SemiHidden=\"false\"\nUnhideWhenUsed=\"false\" QFormat=\"true\" Name=\"List Paragraph\" \/>\n<w:LsdException Locked=\"false\" Priority=\"29\" SemiHidden=\"false\"\nUnhideWhenUsed=\"false\" QFormat=\"true\" Name=\"Quote\" \/>\n<w:LsdException Locked=\"false\" Priority=\"30\" SemiHidden=\"false\"\nUnhideWhenUsed=\"false\" QFormat=\"true\" Name=\"Intense Quote\" \/>\n<w:LsdException Locked=\"false\" Priority=\"66\" SemiHidden=\"false\"\nUnhideWhenUsed=\"false\" Name=\"Medium List 2 Accent 1\" \/>\n<w:LsdException Locked=\"false\" Priority=\"67\" SemiHidden=\"false\"\nUnhideWhenUsed=\"false\" Name=\"Medium Grid 1 Accent 1\" \/>\n<w:LsdException Locked=\"false\" Priority=\"68\" SemiHidden=\"false\"\nUnhideWhenUsed=\"false\" Name=\"Medium Grid 2 Accent 1\" \/>\n<w:LsdException Locked=\"false\" Priority=\"69\" SemiHidden=\"false\"\nUnhideWhenUsed=\"false\" Name=\"Medium Grid 3 Accent 1\" \/>\n<w:LsdException Locked=\"false\" Priority=\"70\" SemiHidden=\"false\"\nUnhideWhenUsed=\"false\" Name=\"Dark List Accent 1\" \/>\n<w:LsdException Locked=\"false\" Priority=\"71\" SemiHidden=\"false\"\nUnhideWhenUsed=\"false\" Name=\"Colorful Shading Accent 1\" \/>\n<w:LsdException Locked=\"false\" Priority=\"72\" SemiHidden=\"false\"\nUnhideWhenUsed=\"false\" Name=\"Colorful List Accent 1\" \/>\n<w:LsdException Locked=\"false\" Priority=\"73\" SemiHidden=\"false\"\nUnhideWhenUsed=\"false\" Name=\"Colorful Grid Accent 1\" \/>\n<w:LsdException Locked=\"false\" Priority=\"60\" SemiHidden=\"false\"\nUnhideWhenUsed=\"false\" Name=\"Light Shading Accent 2\" \/>\n<w:LsdException Locked=\"false\" Priority=\"61\" SemiHidden=\"false\"\nUnhideWhenUsed=\"false\" Name=\"Light List Accent 2\" \/>\n<w:LsdException Locked=\"false\" Priority=\"62\" SemiHidden=\"false\"\nUnhideWhenUsed=\"false\" Name=\"Light Grid Accent 2\" \/>\n<w:LsdException Locked=\"false\" Priority=\"63\" SemiHidden=\"false\"\nUnhideWhenUsed=\"false\" Name=\"Medium Shading 1 Accent 2\" \/>\n<w:LsdException Locked=\"false\" Priority=\"64\" SemiHidden=\"false\"\nUnhideWhenUsed=\"false\" Name=\"Medium Shading 2 Accent 2\" \/>\n<w:LsdException Locked=\"false\" Priority=\"65\" SemiHidden=\"false\"\nUnhideWhenUsed=\"false\" Name=\"Medium List 1 Accent 2\" \/>\n<w:LsdException Locked=\"false\" Priority=\"66\" SemiHidden=\"false\"\nUnhideWhenUsed=\"false\" Name=\"Medium List 2 Accent 2\" \/>\n<w:LsdException Locked=\"false\" Priority=\"67\" SemiHidden=\"false\"\nUnhideWhenUsed=\"false\" Name=\"Medium Grid 1 Accent 2\" \/>\n<w:LsdException Locked=\"false\" Priority=\"68\" SemiHidden=\"false\"\nUnhideWhenUsed=\"false\" Name=\"Medium Grid 2 Accent 2\" \/>\n<w:LsdException Locked=\"false\" Priority=\"69\" SemiHidden=\"false\"\nUnhideWhenUsed=\"false\" Name=\"Medium Grid 3 Accent 2\" \/>\n<w:LsdException Locked=\"false\" Priority=\"70\" SemiHidden=\"false\"\nUnhideWhenUsed=\"false\" Name=\"Dark List Accent 2\" \/>\n<w:LsdException Locked=\"false\" Priority=\"71\" SemiHidden=\"false\"\nUnhideWhenUsed=\"false\" Name=\"Colorful Shading Accent 2\" \/>\n<w:LsdException Locked=\"false\" Priority=\"72\" SemiHidden=\"false\"\nUnhideWhenUsed=\"false\" Name=\"Colorful List Accent 2\" \/>\n<w:LsdException Locked=\"false\" Priority=\"73\" SemiHidden=\"false\"\nUnhideWhenUsed=\"false\" Name=\"Colorful Grid Accent 2\" \/>\n<w:LsdException Locked=\"false\" Priority=\"60\" SemiHidden=\"false\"\nUnhideWhenUsed=\"false\" Name=\"Light Shading Accent 3\" \/>\n<w:LsdException Locked=\"false\" Priority=\"61\" SemiHidden=\"false\"\nUnhideWhenUsed=\"false\" Name=\"Light List Accent 3\" \/>\n<w:LsdException Locked=\"false\" Priority=\"62\" SemiHidden=\"false\"\nUnhideWhenUsed=\"false\" Name=\"Light Grid Accent 3\" \/>\n<w:LsdException Locked=\"false\" Priority=\"63\" SemiHidden=\"false\"\nUnhideWhenUsed=\"false\" Name=\"Medium Shading 1 Accent 3\" \/>\n<w:LsdException Locked=\"false\" Priority=\"64\" SemiHidden=\"false\"\nUnhideWhenUsed=\"false\" Name=\"Medium Shading 2 Accent 3\" \/>\n<w:LsdException Locked=\"false\" Priority=\"65\" SemiHidden=\"false\"\nUnhideWhenUsed=\"false\" Name=\"Medium List 1 Accent 3\" \/>\n<w:LsdException Locked=\"false\" Priority=\"66\" SemiHidden=\"false\"\nUnhideWhenUsed=\"false\" Name=\"Medium List 2 Accent 3\" \/>\n<w:LsdException Locked=\"false\" Priority=\"67\" SemiHidden=\"false\"\nUnhideWhenUsed=\"false\" Name=\"Medium Grid 1 Accent 3\" \/>\n<w:LsdException Locked=\"false\" Priority=\"68\" SemiHidden=\"false\"\nUnhideWhenUsed=\"false\" Name=\"Medium Grid 2 Accent 3\" \/>\n<w:LsdException Locked=\"false\" Priority=\"69\" SemiHidden=\"false\"\nUnhideWhenUsed=\"false\" Name=\"Medium Grid 3 Accent 3\" \/>\n<w:LsdException Locked=\"false\" Priority=\"70\" SemiHidden=\"false\"\nUnhideWhenUsed=\"false\" Name=\"Dark List Accent 3\" \/>\n<w:LsdException Locked=\"false\" Priority=\"71\" SemiHidden=\"false\"\nUnhideWhenUsed=\"false\" Name=\"Colorful Shading Accent 3\" \/>\n<w:LsdException Locked=\"false\" Priority=\"72\" SemiHidden=\"false\"\nUnhideWhenUsed=\"false\" Name=\"Colorful List Accent 3\" \/>\n<w:LsdException Locked=\"false\" Priority=\"73\" SemiHidden=\"false\"\nUnhideWhenUsed=\"false\" Name=\"Colorful Grid Accent 3\" \/>\n<w:LsdException Locked=\"false\" Priority=\"60\" SemiHidden=\"false\"\nUnhideWhenUsed=\"false\" Name=\"Light Shading Accent 4\" \/>\n<w:LsdException Locked=\"false\" Priority=\"61\" SemiHidden=\"false\"\nUnhideWhenUsed=\"false\" Name=\"Light List Accent 4\" \/>\n<w:LsdException Locked=\"false\" Priority=\"62\" SemiHidden=\"false\"\nUnhideWhenUsed=\"false\" Name=\"Light Grid Accent 4\" \/>\n<w:LsdException Locked=\"false\" Priority=\"63\" SemiHidden=\"false\"\nUnhideWhenUsed=\"false\" Name=\"Medium Shading 1 Accent 4\" \/>\n<w:LsdException Locked=\"false\" Priority=\"64\" SemiHidden=\"false\"\nUnhideWhenUsed=\"false\" Name=\"Medium Shading 2 Accent 4\" \/>\n<w:LsdException Locked=\"false\" Priority=\"65\" SemiHidden=\"false\"\nUnhideWhenUsed=\"false\" Name=\"Medium List 1 Accent 4\" \/>\n<w:LsdException Locked=\"false\" Priority=\"66\" SemiHidden=\"false\"\nUnhideWhenUsed=\"false\" Name=\"Medium List 2 Accent 4\" \/>\n<w:LsdException Locked=\"false\" Priority=\"67\" SemiHidden=\"false\"\nUnhideWhenUsed=\"false\" Name=\"Medium Grid 1 Accent 4\" \/>\n<w:LsdException Locked=\"false\" Priority=\"68\" SemiHidden=\"false\"\nUnhideWhenUsed=\"false\" Name=\"Medium Grid 2 Accent 4\" \/>\n<w:LsdException Locked=\"false\" Priority=\"69\" SemiHidden=\"false\"\nUnhideWhenUsed=\"false\" Name=\"Medium Grid 3 Accent 4\" \/>\n<w:LsdException Locked=\"false\" Priority=\"70\" SemiHidden=\"false\"\nUnhideWhenUsed=\"false\" Name=\"Dark List Accent 4\" \/>\n<w:LsdException Locked=\"false\" Priority=\"71\" SemiHidden=\"false\"\nUnhideWhenUsed=\"false\" Name=\"Colorful Shading Accent 4\" \/>\n<w:LsdException Locked=\"false\" Priority=\"72\" SemiHidden=\"false\"\nUnhideWhenUsed=\"false\" Name=\"Colorful List Accent 4\" \/>\n<w:LsdException Locked=\"false\" Priority=\"73\" SemiHidden=\"false\"\nUnhideWhenUsed=\"false\" Name=\"Colorful Grid Accent 4\" \/>\n<w:LsdException Locked=\"false\" Priority=\"60\" SemiHidden=\"false\"\nUnhideWhenUsed=\"false\" Name=\"Light Shading Accent 5\" \/>\n<w:LsdException Locked=\"false\" Priority=\"61\" SemiHidden=\"false\"\nUnhideWhenUsed=\"false\" Name=\"Light List Accent 5\" \/>\n<w:LsdException Locked=\"false\" Priority=\"62\" SemiHidden=\"false\"\nUnhideWhenUsed=\"false\" Name=\"Light Grid Accent 5\" \/>\n<w:LsdException Locked=\"false\" Priority=\"63\" SemiHidden=\"false\"\nUnhideWhenUsed=\"false\" Name=\"Medium Shading 1 Accent 5\" \/>\n<w:LsdException Locked=\"false\" Priority=\"64\" SemiHidden=\"false\"\nUnhideWhenUsed=\"false\" Name=\"Medium Shading 2 Accent 5\" \/>\n<w:LsdException Locked=\"false\" Priority=\"65\" SemiHidden=\"false\"\nUnhideWhenUsed=\"false\" Name=\"Medium List 1 Accent 5\" \/>\n<w:LsdException Locked=\"false\" Priority=\"66\" SemiHidden=\"false\"\nUnhideWhenUsed=\"false\" Name=\"Medium List 2 Accent 5\" \/>\n<w:LsdException Locked=\"false\" Priority=\"67\" SemiHidden=\"false\"\nUnhideWhenUsed=\"false\" Name=\"Medium Grid 1 Accent 5\" \/>\n<w:LsdException Locked=\"false\" Priority=\"68\" SemiHidden=\"false\"\nUnhideWhenUsed=\"false\" Name=\"Medium Grid 2 Accent 5\" \/>\n<w:LsdException Locked=\"false\" Priority=\"69\" SemiHidden=\"false\"\nUnhideWhenUsed=\"false\" Name=\"Medium Grid 3 Accent 5\" \/>\n<w:LsdException Locked=\"false\" Priority=\"70\" SemiHidden=\"false\"\nUnhideWhenUsed=\"false\" Name=\"Dark List Accent 5\" \/>\n<w:LsdException Locked=\"false\" Priority=\"71\" SemiHidden=\"false\"\nUnhideWhenUsed=\"false\" Name=\"Colorful Shading Accent 5\" \/>\n<w:LsdException Locked=\"false\" Priority=\"72\" SemiHidden=\"false\"\nUnhideWhenUsed=\"false\" Name=\"Colorful List Accent 5\" \/>\n<w:LsdException Locked=\"false\" Priority=\"73\" SemiHidden=\"false\"\nUnhideWhenUsed=\"false\" Name=\"Colorful Grid Accent 5\" \/>\n<w:LsdException Locked=\"false\" Priority=\"60\" SemiHidden=\"false\"\nUnhideWhenUsed=\"false\" Name=\"Light Shading Accent 6\" \/>\n<w:LsdException Locked=\"false\" Priority=\"61\" SemiHidden=\"false\"\nUnhideWhenUsed=\"false\" Name=\"Light List Accent 6\" \/>\n<w:LsdException Locked=\"false\" Priority=\"62\" SemiHidden=\"false\"\nUnhideWhenUsed=\"false\" Name=\"Light Grid Accent 6\" \/>\n<w:LsdException Locked=\"false\" Priority=\"63\" SemiHidden=\"false\"\nUnhideWhenUsed=\"false\" Name=\"Medium Shading 1 Accent 6\" \/>\n<w:LsdException Locked=\"false\" Priority=\"64\" SemiHidden=\"false\"\nUnhideWhenUsed=\"false\" Name=\"Medium Shading 2 Accent 6\" \/>\n<w:LsdException Locked=\"false\" Priority=\"65\" SemiHidden=\"false\"\nUnhideWhenUsed=\"false\" Name=\"Medium List 1 Accent 6\" \/>\n<w:LsdException Locked=\"false\" Priority=\"66\" SemiHidden=\"false\"\nUnhideWhenUsed=\"false\" Name=\"Medium List 2 Accent 6\" \/>\n<w:LsdException Locked=\"false\" Priority=\"67\" SemiHidden=\"false\"\nUnhideWhenUsed=\"false\" Name=\"Medium Grid 1 Accent 6\" \/>\n<w:LsdException Locked=\"false\" Priority=\"68\" SemiHidden=\"false\"\nUnhideWhenUsed=\"false\" Name=\"Medium Grid 2 Accent 6\" \/>\n<w:LsdException Locked=\"false\" Priority=\"69\" SemiHidden=\"false\"\nUnhideWhenUsed=\"false\" Name=\"Medium Grid 3 Accent 6\" \/>\n<w:LsdException Locked=\"false\" Priority=\"70\" SemiHidden=\"false\"\nUnhideWhenUsed=\"false\" Name=\"Dark List Accent 6\" \/>\n<w:LsdException Locked=\"false\" Priority=\"71\" SemiHidden=\"false\"\nUnhideWhenUsed=\"false\" Name=\"Colorful Shading Accent 6\" \/>\n<w:LsdException Locked=\"false\" Priority=\"72\" SemiHidden=\"false\"\nUnhideWhenUsed=\"false\" Name=\"Colorful List Accent 6\" \/>\n<w:LsdException Locked=\"false\" Priority=\"73\" SemiHidden=\"false\"\nUnhideWhenUsed=\"false\" Name=\"Colorful Grid Accent 6\" \/>\n<w:LsdException Locked=\"false\" Priority=\"19\" SemiHidden=\"false\"\nUnhideWhenUsed=\"false\" QFormat=\"true\" Name=\"Subtle Emphasis\" \/>\n<w:LsdException Locked=\"false\" Priority=\"21\" SemiHidden=\"false\"\nUnhideWhenUsed=\"false\" QFormat=\"true\" Name=\"Intense Emphasis\" \/>\n<w:LsdException Locked=\"false\" Priority=\"31\" SemiHidden=\"false\"\nUnhideWhenUsed=\"false\" QFormat=\"true\" Name=\"Subtle Reference\" \/>\n<w:LsdException Locked=\"false\" Priority=\"32\" SemiHidden=\"false\"\nUnhideWhenUsed=\"false\" QFormat=\"true\" Name=\"Intense Reference\" \/>\n<w:LsdException Locked=\"false\" Priority=\"33\" SemiHidden=\"false\"\nUnhideWhenUsed=\"false\" QFormat=\"true\" Name=\"Book Title\" \/>\n<w:LsdException Locked=\"false\" Priority=\"37\" Name=\"Bibliography\" \/>\n<w:LsdException Locked=\"false\" Priority=\"39\" QFormat=\"true\" Name=\"TOC Heading\" \/>\n<\/w:LatentStyles>\n<\/xml><![endif]--><style type=\"text\/css\">\n<!--\n \/* Font Definitions *\/\n @font-face\n\t{font-family:\"Cambria Math\";\n\tpanose-1:2 4 5 3 5 4 6 3 2 4;\n\tmso-font-charset:162;\n\tmso-generic-font-family:roman;\n\tmso-font-pitch:variable;\n\tmso-font-signature:-1610611985 1107304683 0 0 415 0;}\n@font-face\n\t{font-family:Calibri;\n\tpanose-1:2 15 5 2 2 2 4 3 2 4;\n\tmso-font-charset:162;\n\tmso-generic-font-family:swiss;\n\tmso-font-pitch:variable;\n\tmso-font-signature:-520092929 1073786111 9 0 415 0;}\n@font-face\n\t{font-family:\"Segoe UI\";\n\tpanose-1:2 11 5 2 4 2 4 2 2 3;\n\tmso-font-charset:162;\n\tmso-generic-font-family:swiss;\n\tmso-font-pitch:variable;\n\tmso-font-signature:-520084737 -1073683329 41 0 479 0;}\n \/* Style Definitions *\/\n p.MsoNormal, li.MsoNormal, div.MsoNormal\n\t{mso-style-unhide:no;\n\tmso-style-qformat:yes;\n\tmso-style-parent:\"\";\n\tmargin-top:0cm;\n\tmargin-right:0cm;\n\tmargin-bottom:10.0pt;\n\tmargin-left:0cm;\n\tline-height:115%;\n\tmso-pagination:widow-orphan;\n\tfont-size:11.0pt;\n\tfont-family:\"Calibri\",\"sans-serif\";\n\tmso-ascii-font-family:Calibri;\n\tmso-ascii-theme-font:minor-latin;\n\tmso-fareast-font-family:Calibri;\n\tmso-fareast-theme-font:minor-latin;\n\tmso-hansi-font-family:Calibri;\n\tmso-hansi-theme-font:minor-latin;\n\tmso-bidi-font-family:\"Times New Roman\";\n\tmso-bidi-theme-font:minor-bidi;\n\tmso-fareast-language:EN-US;}\np\n\t{mso-style-priority:99;\n\tmso-margin-top-alt:auto;\n\tmargin-right:0cm;\n\tmso-margin-bottom-alt:auto;\n\tmargin-left:0cm;\n\tmso-pagination:widow-orphan;\n\tfont-size:12.0pt;\n\tfont-family:\"Times New Roman\",\"serif\";\n\tmso-fareast-font-family:\"Times New Roman\";}\n.MsoChpDefault\n\t{mso-style-type:export-only;\n\tmso-default-props:yes;\n\tmso-ascii-font-family:Calibri;\n\tmso-ascii-theme-font:minor-latin;\n\tmso-fareast-font-family:Calibri;\n\tmso-fareast-theme-font:minor-latin;\n\tmso-hansi-font-family:Calibri;\n\tmso-hansi-theme-font:minor-latin;\n\tmso-bidi-font-family:\"Times New Roman\";\n\tmso-bidi-theme-font:minor-bidi;\n\tmso-fareast-language:EN-US;}\n.MsoPapDefault\n\t{mso-style-type:export-only;\n\tmargin-bottom:10.0pt;\n\tline-height:115%;}\n@page Section1\n\t{size:595.3pt 841.9pt;\n\tmargin:70.85pt 70.85pt 70.85pt 70.85pt;\n\tmso-header-margin:35.4pt;\n\tmso-footer-margin:35.4pt;\n\tmso-paper-source:0;}\ndiv.Section1\n\t{page:Section1;}\n-->\n<\/style><!--[if gte mso 10]>\n<style>\n\/* Style Definitions *\/\ntable.MsoNormalTable\n{mso-style-name:\"Normal Tablo\";\nmso-tstyle-rowband-size:0;\nmso-tstyle-colband-size:0;\nmso-style-noshow:yes;\nmso-style-priority:99;\nmso-style-qformat:yes;\nmso-style-parent:\"\";\nmso-padding-alt:0cm 5.4pt 0cm 5.4pt;\nmso-para-margin-top:0cm;\nmso-para-margin-right:0cm;\nmso-para-margin-bottom:10.0pt;\nmso-para-margin-left:0cm;\nline-height:115%;\nmso-pagination:widow-orphan;\nfont-size:11.0pt;\nfont-family:\"Calibri\",\"sans-serif\";\nmso-ascii-font-family:Calibri;\nmso-ascii-theme-font:minor-latin;\nmso-fareast-font-family:\"Times New Roman\";\nmso-fareast-theme-font:minor-fareast;\nmso-hansi-font-family:Calibri;\nmso-hansi-theme-font:minor-latin;\nmso-bidi-font-family:\"Times New Roman\";\nmso-bidi-theme-font:minor-bidi;}\ntable.MsoTableGrid\n{mso-style-name:\"Tablo Kilavuzu\";\nmso-tstyle-rowband-size:0;\nmso-tstyle-colband-size:0;\nmso-style-priority:59;\nmso-style-unhide:no;\nborder:solid black 1.0pt;\nmso-border-themecolor:text1;\nmso-border-alt:solid black .5pt;\nmso-border-themecolor:text1;\nmso-padding-alt:0cm 5.4pt 0cm 5.4pt;\nmso-border-insideh:.5pt solid black;\nmso-border-insideh-themecolor:text1;\nmso-border-insidev:.5pt solid black;\nmso-border-insidev-themecolor:text1;\nmso-para-margin:0cm;\nmso-para-margin-bottom:.0001pt;\nmso-pagination:widow-orphan;\nfont-size:11.0pt;\nfont-family:\"Calibri\",\"sans-serif\";\nmso-ascii-font-family:Calibri;\nmso-ascii-theme-font:minor-latin;\nmso-hansi-font-family:Calibri;\nmso-hansi-theme-font:minor-latin;\nmso-bidi-font-family:\"Times New Roman\";\nmso-bidi-theme-font:minor-bidi;\nmso-fareast-language:EN-US;}\n<\/style>\n<![endif]--><\/p>\n<p><strong><i><span style=\"font-size: 10pt; font-family: &quot;Segoe UI&quot;,&quot;sans-serif&quot;;\">INSERT (Bir Kayit Eklemek)<\/span><\/i><\/strong><span style=\"font-size: 10pt; font-family: &quot;Segoe UI&quot;,&quot;sans-serif&quot;;\"><br \/>\n<br \/>\nTablomuza bir kayit eklemek i&ccedil;in kullanilir.<\/span><\/p>\n<p><span style=\"font-size: 10pt; font-family: &quot;Segoe UI&quot;,&quot;sans-serif&quot;;\"><a href='www.yazilimmutfagi.com'>.<\/a><o:p><\/o:p><\/span><\/p>\n<table cellspacing=\"0\" cellpadding=\"0\" border=\"1\" style=\"border: medium none ; background: rgb(242, 242, 242) none repeat scroll 0% 0%; margin-left: 5.4pt; -moz-background-clip: border; -moz-background-origin: padding; -moz-background-inline-policy: continuous; border-collapse: collapse;\" class=\"MsoTableGrid\">\n    <tbody>\n        <tr style=\"\">\n            <td valign=\"top\" width=\"567\" style=\"border: 1pt solid black; padding: 0cm 5.4pt; width: 15cm;\">\n            <p style=\"margin-bottom: 0.0001pt; line-height: normal;\" class=\"MsoNormal\"><span style=\"font-size: 10pt; font-family: &quot;Courier New&quot;; color: blue;\">INSERT<\/span><span style=\"font-size: 10pt; font-family: &quot;Courier New&quot;;\"> <span style=\"color: blue;\">INTO<\/span> tablo_adi<span style=\"color: blue;\"> <\/span><span style=\"color: gray;\">(<\/span>sutun1 [,sutun2,   &hellip; ]<span style=\"color: gray;\">)<o:p><\/o:p><\/span><\/span><\/p>\n            <p style=\"margin-bottom: 0.0001pt; line-height: normal;\" class=\"MsoNormal\"><span style=\"font-size: 10pt; font-family: &quot;Courier New&quot;; color: blue;\">VALUES <\/span><span style=\"font-size: 10pt; font-family: &quot;Courier New&quot;; color: gray;\">(<\/span><span style=\"font-size: 10pt; font-family: &quot;Courier New&quot;;\">deger1 [,deger2, &hellip;]<span style=\"color: gray;\">)<\/span><\/span><span style=\"font-size: 10pt; font-family: &quot;Segoe UI&quot;,&quot;sans-serif&quot;;\"><o:p><\/o:p><\/span><\/p>\n            <\/td>\n        <\/tr>\n    <\/tbody>\n<\/table>\n<p><span style=\"font-size: 10pt; font-family: &quot;Segoe UI&quot;,&quot;sans-serif&quot;;\">Simdi TEST isimli veritabanimizin deneme isimli tablosuna bir kayit ekleyelim. Bu ekleme isleminde degerlerin t&uuml;rlerinden dolayi tirnak ifadesi i&ccedil;inde olmasina dikkat etmeliyiz.<o:p><\/o:p><\/span><\/p>\n<table cellspacing=\"0\" cellpadding=\"0\" border=\"1\" style=\"border: medium none ; background: rgb(242, 242, 242) none repeat scroll 0% 0%; margin-left: 5.4pt; -moz-background-clip: border; -moz-background-origin: padding; -moz-background-inline-policy: continuous; border-collapse: collapse;\" class=\"MsoTableGrid\">\n    <tbody>\n        <tr style=\"\">\n            <td valign=\"top\" width=\"567\" style=\"border: 1pt solid black; padding: 0cm 5.4pt; width: 15cm;\">\n            <p style=\"margin-bottom: 0.0001pt; line-height: normal;\" class=\"MsoNormal\"><span style=\"font-size: 10pt; font-family: &quot;Courier New&quot;; color: blue;\">USE<\/span><span style=\"font-size: 10pt; font-family: &quot;Courier New&quot;;\"> TEST<o:p><\/o:p><\/span><\/p>\n            <p style=\"margin-bottom: 0.0001pt; line-height: normal;\" class=\"MsoNormal\"><span style=\"font-size: 10pt; font-family: &quot;Courier New&quot;; color: blue;\">GO<o:p><\/o:p><\/span><\/p>\n            <p style=\"margin-bottom: 0.0001pt; line-height: normal;\" class=\"MsoNormal\"><span style=\"font-size: 10pt; font-family: &quot;Courier New&quot;; color: blue;\">INSERT<\/span><span style=\"font-size: 10pt; font-family: &quot;Courier New&quot;;\"> <span style=\"color: blue;\">INTO<\/span> deneme<span style=\"color: blue;\"> <\/span><span style=\"color: gray;\">(<\/span>isim<span style=\"color: gray;\">,<\/span>soyad<span style=\"color: gray;\">) <\/span><span style=\"color: blue;\">VALUES <\/span><span style=\"color: gray;\">(<\/span>&lsquo;Mehtap&rsquo;<span style=\"color: gray;\">,<\/span>&rsquo;Arman&rsquo;<span style=\"color: gray;\">)<o:p><\/o:p><\/span><\/span><\/p>\n            <\/td>\n        <\/tr>\n    <\/tbody>\n<\/table>\n<p><strong><i><span style=\"font-size: 10pt; font-family: &quot;Segoe UI&quot;,&quot;sans-serif&quot;;\">SELECT (Se&ccedil;me ve Filtreleme)<\/span><\/i><\/strong><span style=\"font-size: 10pt; font-family: &quot;Segoe UI&quot;,&quot;sans-serif&quot;;\"><br \/>\n<br \/>\nBir tabloya girilmis olan kayitlari se&ccedil;mek i&ccedil;in kullanilmaktadir. Yalin bir sekilde kalip su sekildedir.<o:p><\/o:p><\/span><\/p>\n<table cellspacing=\"0\" cellpadding=\"0\" border=\"1\" style=\"border: medium none ; background: rgb(242, 242, 242) none repeat scroll 0% 0%; margin-left: 5.4pt; -moz-background-clip: border; -moz-background-origin: padding; -moz-background-inline-policy: continuous; border-collapse: collapse;\" class=\"MsoTableGrid\">\n    <tbody>\n        <tr style=\"\">\n            <td valign=\"top\" width=\"567\" style=\"border: 1pt solid black; padding: 0cm 5.4pt; width: 15cm;\">\n            <p style=\"margin-bottom: 0.0001pt; line-height: normal;\" class=\"MsoNormal\"><span style=\"font-size: 10pt; font-family: &quot;Courier New&quot;; color: blue;\">SELECT<\/span><span style=\"font-size: 10pt; font-family: &quot;Courier New&quot;;\"> sutun_ismi1 [,sutun_ismi2, &hellip;]<span style=\"\">&nbsp; <\/span><span style=\"color: gray;\">|<\/span> <span style=\"color: gray;\">*<\/span> <span style=\"color: blue;\">from<\/span> tablo_adi<\/span><span style=\"font-size: 10pt; font-family: &quot;Segoe UI&quot;,&quot;sans-serif&quot;;\"><o:p><\/o:p><\/span><\/p>\n            <\/td>\n        <\/tr>\n    <\/tbody>\n<\/table>\n<p><span style=\"font-size: 10pt; font-family: &quot;Segoe UI&quot;,&quot;sans-serif&quot;;\">simdide bir &ouml;nce ki adimda ekledigimiz kayita eriselim.<o:p><\/o:p><\/span><\/p>\n<table cellspacing=\"0\" cellpadding=\"0\" border=\"1\" style=\"border: medium none ; background: rgb(242, 242, 242) none repeat scroll 0% 0%; margin-left: 5.4pt; -moz-background-clip: border; -moz-background-origin: padding; -moz-background-inline-policy: continuous; border-collapse: collapse;\" class=\"MsoTableGrid\">\n    <tbody>\n        <tr style=\"\">\n            <td valign=\"top\" width=\"567\" style=\"border: 1pt solid black; padding: 0cm 5.4pt; width: 15cm;\">\n            <p style=\"margin-bottom: 0.0001pt; line-height: normal;\" class=\"MsoNormal\"><span style=\"font-size: 10pt; font-family: &quot;Courier New&quot;; color: blue;\">USE<\/span><span style=\"font-size: 10pt; font-family: &quot;Courier New&quot;;\"> TEST<o:p><\/o:p><\/span><\/p>\n            <p style=\"margin-bottom: 0.0001pt; line-height: normal;\" class=\"MsoNormal\"><span style=\"font-size: 10pt; font-family: &quot;Courier New&quot;; color: blue;\">GO<o:p><\/o:p><\/span><\/p>\n            <p style=\"margin-bottom: 0.0001pt; line-height: normal;\" class=\"MsoNormal\"><span style=\"font-size: 10pt; font-family: &quot;Courier New&quot;; color: blue;\">SELECT<\/span><span style=\"font-size: 10pt; font-family: &quot;Courier New&quot;;\"> <span style=\"color: gray;\">* <\/span><span style=\"color: blue;\">FROM<\/span>   deneme<\/span><span style=\"font-size: 10pt; font-family: &quot;Segoe UI&quot;,&quot;sans-serif&quot;;\"><o:p><\/o:p><\/span><\/p>\n            <\/td>\n        <\/tr>\n    <\/tbody>\n<\/table>\n<p><strong><i><span style=\"font-size: 10pt; font-family: &quot;Segoe UI&quot;,&quot;sans-serif&quot;;\">Iki Alan Birlestirilmesi<\/span><\/i><\/strong><b><i><span style=\"font-size: 10pt; font-family: &quot;Segoe UI&quot;,&quot;sans-serif&quot;;\"><br \/>\n<\/span><\/i><\/b><span style=\"font-size: 10pt; font-family: &quot;Segoe UI&quot;,&quot;sans-serif&quot;;\"><br \/>\nKarakter (CHAR, VARCHAR &hellip; gibi) alanlar, bir tek alanmis gibi u&ccedil; uca ulanabilir. Bu islem karakter i&ccedil;ermeyen verilerde karakter d&ouml;n&uuml;st&uuml;rme fonksiyonlari kullanilarak yapilabilir.<br \/>\nDeneme tablomuzda olan isim ve soyad alanlarini tek bir alan gibi g&ouml;sterip birlestiren kod asagida ki gibidir.<o:p><\/o:p><\/span><\/p>\n<table cellspacing=\"0\" cellpadding=\"0\" border=\"1\" style=\"border: medium none ; background: rgb(242, 242, 242) none repeat scroll 0% 0%; margin-left: 5.4pt; -moz-background-clip: border; -moz-background-origin: padding; -moz-background-inline-policy: continuous; border-collapse: collapse;\" class=\"MsoTableGrid\">\n    <tbody>\n        <tr style=\"\">\n            <td valign=\"top\" width=\"567\" style=\"border: 1pt solid black; padding: 0cm 5.4pt; width: 15cm;\">\n            <p style=\"margin-bottom: 0.0001pt; line-height: normal;\" class=\"MsoNormal\"><span style=\"font-size: 10pt; font-family: &quot;Courier New&quot;; color: blue;\">SELECT<\/span><span style=\"font-size: 10pt; font-family: &quot;Courier New&quot;;\"> isim <span style=\"color: gray;\">+<\/span> <span style=\"color: red;\">&#8221;<\/span> <span style=\"color: gray;\">+<\/span> soyad <span style=\"color: blue;\">FROM<\/span> deneme<\/span><span style=\"font-size: 10pt; font-family: &quot;Segoe UI&quot;,&quot;sans-serif&quot;;\"><o:p><\/o:p><\/span><\/p>\n            <\/td>\n        <\/tr>\n    <\/tbody>\n<\/table>\n<p><span style=\"font-size: 10pt; font-family: &quot;Segoe UI&quot;,&quot;sans-serif&quot;;\"><a href='www.yazilimmutfagi.com'>.<\/a><\/span><\/p>\n<p><strong><i><span style=\"font-size: 10pt; font-family: &quot;Segoe UI&quot;,&quot;sans-serif&quot;;\">Se&ccedil;ilen Kayitlarin Siralanmasi<\/span><\/i><\/strong><span style=\"font-size: 10pt; font-family: &quot;Segoe UI&quot;,&quot;sans-serif&quot;;\"><br \/>\n&nbsp;<br \/>\nse&ccedil;ilen kayitlarin siralanmasi isleminde ORDER BY yan c&uuml;mlecigi kullanilmaktadir. ORDER BY ifadesinden daha sonra siralamada baz alinacak alanin yada alanlarin isimleri gelir. Alan birden fazla ise aralarina virg&uuml;l konulur ve ilk alanda esitlik s&ouml;z konusu ise sonraki alana g&ouml;re yeniden siralanir. Alandan daha sonra ASC ve DESC anahtar kelimeleri gelmektedir. ASC anahtar kelimesi artarak siralama DESC ise azalarak siralama olusturmaktadir. Eger s&uuml;t&uuml;n sonrasinda bu iki ifadeden hi&ccedil; biri yoksa ASC var olarak kabul edilir.<br style=\"\" \/>\n<!--[if !supportLineBreakNewLine]--><br style=\"\" \/>\n<!--[endif]--><o:p><\/o:p><\/span><\/p>\n<table cellspacing=\"0\" cellpadding=\"0\" border=\"1\" style=\"border: medium none ; background: rgb(242, 242, 242) none repeat scroll 0% 0%; margin-left: 5.4pt; -moz-background-clip: border; -moz-background-origin: padding; -moz-background-inline-policy: continuous; border-collapse: collapse;\" class=\"MsoTableGrid\">\n    <tbody>\n        <tr style=\"\">\n            <td valign=\"top\" width=\"567\" style=\"border: 1pt solid black; padding: 0cm 5.4pt; width: 15cm;\">\n            <p style=\"margin-bottom: 0.0001pt; line-height: normal;\" class=\"MsoNormal\"><span style=\"font-size: 10pt; font-family: &quot;Courier New&quot;; color: blue;\">SELECT<\/span><span style=\"font-size: 10pt; font-family: &quot;Courier New&quot;;\"> sutun_ismi1 [,sutun_ismi2, &hellip;] <span style=\"color: gray;\">|<\/span>   <span style=\"color: gray;\">*<\/span> <o:p><\/o:p><\/span><\/p>\n            <p style=\"margin-bottom: 0.0001pt; line-height: normal;\" class=\"MsoNormal\"><span style=\"font-size: 10pt; font-family: &quot;Courier New&quot;; color: blue;\">FROM<\/span><span style=\"font-size: 10pt; font-family: &quot;Courier New&quot;;\"> tablo_ismi <o:p><\/o:p><\/span><\/p>\n            <p style=\"margin-bottom: 0.0001pt; line-height: normal;\" class=\"MsoNormal\"><span style=\"font-size: 10pt; font-family: &quot;Courier New&quot;; color: blue;\">ORDER<\/span><span style=\"font-size: 10pt; font-family: &quot;Courier New&quot;;\"> <span style=\"color: blue;\">BY<\/span> sutun3 <span style=\"color: gray;\">|<\/span> sutun3_no [ASC | DESC , sutun4 ASC | DESC] &hellip;<\/span><span style=\"font-size: 10pt; font-family: &quot;Segoe UI&quot;,&quot;sans-serif&quot;;\"><o:p><\/o:p><\/span><\/p>\n            <\/td>\n        <\/tr>\n    <\/tbody>\n<\/table>\n<p><strong><i><span style=\"font-size: 10pt; font-family: &quot;Segoe UI&quot;,&quot;sans-serif&quot;;\">Kayitlarin Filtrelenmesi ve WHERE C&uuml;mlecigi<\/span><\/i><\/strong><span style=\"font-size: 10pt; font-family: &quot;Segoe UI&quot;,&quot;sans-serif&quot;;\"><o:p><\/o:p><\/span><\/p>\n<p><span style=\"font-size: 10pt; font-family: &quot;Segoe UI&quot;,&quot;sans-serif&quot;;\">WHERE c&uuml;mlecigi ile kayitlarimizdan hangilerinin sorgu sonucu getirilip, hangilerinin getirilmeyecegini belirleyebiliriz.<o:p><\/o:p><\/span><\/p>\n<table cellspacing=\"0\" cellpadding=\"0\" border=\"1\" style=\"border: medium none ; background: rgb(242, 242, 242) none repeat scroll 0% 0%; margin-left: 5.4pt; -moz-background-clip: border; -moz-background-origin: padding; -moz-background-inline-policy: continuous; border-collapse: collapse;\" class=\"MsoTableGrid\">\n    <tbody>\n        <tr style=\"\">\n            <td valign=\"top\" width=\"567\" style=\"border: 1pt solid black; padding: 0cm 5.4pt; width: 15cm;\">\n            <p style=\"margin-bottom: 0.0001pt; line-height: normal;\" class=\"MsoNormal\"><span style=\"font-size: 10pt; font-family: &quot;Courier New&quot;; color: blue;\">SELECT<\/span><span style=\"font-size: 10pt; font-family: &quot;Courier New&quot;;\"> sutun_isimleri<o:p><\/o:p><\/span><\/p>\n            <p style=\"margin-bottom: 0.0001pt; line-height: normal;\" class=\"MsoNormal\"><span style=\"font-size: 10pt; font-family: &quot;Courier New&quot;; color: blue;\">FROM<\/span><span style=\"font-size: 10pt; font-family: &quot;Courier New&quot;;\"> tablo_ismi <o:p><\/o:p><\/span><\/p>\n            <p style=\"margin-bottom: 0.0001pt; line-height: normal;\" class=\"MsoNormal\"><span style=\"font-size: 10pt; font-family: &quot;Courier New&quot;; color: blue;\">WHERE<\/span><span style=\"font-size: 10pt; font-family: &quot;Courier New&quot;;\"> sart_tanimlari<\/span><span style=\"font-size: 10pt; font-family: &quot;Segoe UI&quot;,&quot;sans-serif&quot;;\"><o:p><\/o:p><\/span><\/p>\n            <\/td>\n        <\/tr>\n    <\/tbody>\n<\/table>\n<p><strong><i><span style=\"font-size: 10pt; font-family: &quot;Segoe UI&quot;,&quot;sans-serif&quot;;\">UPDATE (Veriler &Uuml;zerinde Degisiklik)<\/span><\/i><\/strong><span style=\"font-size: 10pt; font-family: &quot;Segoe UI&quot;,&quot;sans-serif&quot;;\"><o:p><\/o:p><\/span><\/p>\n<p><span style=\"font-size: 10pt; font-family: &quot;Segoe UI&quot;,&quot;sans-serif&quot;;\">UPDATE ifadesi ile satir satir degerleri degistirilebilir. Kullanim sekli temel olarak asagidaki gibidir.<o:p><\/o:p><\/span><\/p>\n<table cellspacing=\"0\" cellpadding=\"0\" border=\"1\" style=\"border: medium none ; background: rgb(242, 242, 242) none repeat scroll 0% 0%; margin-left: 5.4pt; -moz-background-clip: border; -moz-background-origin: padding; -moz-background-inline-policy: continuous; border-collapse: collapse;\" class=\"MsoTableGrid\">\n    <tbody>\n        <tr style=\"\">\n            <td valign=\"top\" width=\"567\" style=\"border: 1pt solid black; padding: 0cm 5.4pt; width: 15cm;\">\n            <p style=\"margin-bottom: 0.0001pt; line-height: normal;\" class=\"MsoNormal\"><span style=\"font-size: 10pt; font-family: &quot;Courier New&quot;; color: blue;\">UPDATE<\/span><span style=\"font-size: 10pt; font-family: &quot;Courier New&quot;;\"> tablo_ismi<o:p><\/o:p><\/span><\/p>\n            <p style=\"margin-bottom: 0.0001pt; line-height: normal;\" class=\"MsoNormal\"><span style=\"font-size: 10pt; font-family: &quot;Courier New&quot;; color: blue;\">SET<\/span><span style=\"font-size: 10pt; font-family: &quot;Courier New&quot;;\"> alan<span style=\"color: gray;\">=<\/span>deger<o:p><\/o:p><\/span><\/p>\n            <p style=\"margin-bottom: 0.0001pt; line-height: normal;\" class=\"MsoNormal\"><span style=\"font-size: 10pt; font-family: &quot;Courier New&quot;; color: blue;\">WHERE<\/span><span style=\"font-size: 10pt; font-family: &quot;Courier New&quot;;\"> sart tanimlamalari<\/span><span style=\"font-size: 10pt; font-family: &quot;Segoe UI&quot;,&quot;sans-serif&quot;;\"><o:p><\/o:p><\/span><\/p>\n            <\/td>\n        <\/tr>\n    <\/tbody>\n<\/table>\n<p><span style=\"font-size: 10pt; font-family: &quot;Segoe UI&quot;,&quot;sans-serif&quot;;\"><a href='www.yazilimmutfagi.com'>.<\/a><\/span><\/p>\n<p><strong><i><span style=\"font-size: 10pt; font-family: &quot;Segoe UI&quot;,&quot;sans-serif&quot;;\">DELETE (Verileri Silmek)<\/span><\/i><\/strong><span style=\"font-size: 10pt; font-family: &quot;Segoe UI&quot;,&quot;sans-serif&quot;;\"><o:p><\/o:p><\/span><\/p>\n<p><span style=\"font-size: 10pt; font-family: &quot;Segoe UI&quot;,&quot;sans-serif&quot;;\">Bir kaydin silinmesi i&ccedil;in DELETE ifadesi&nbsp; kullanilir. Kullanim sekli su sekildedir.<o:p><\/o:p><\/span><\/p>\n<table cellspacing=\"0\" cellpadding=\"0\" border=\"1\" style=\"border: medium none ; background: rgb(242, 242, 242) none repeat scroll 0% 0%; margin-left: 5.4pt; -moz-background-clip: border; -moz-background-origin: padding; -moz-background-inline-policy: continuous; border-collapse: collapse;\" class=\"MsoTableGrid\">\n    <tbody>\n        <tr style=\"\">\n            <td valign=\"top\" width=\"567\" style=\"border: 1pt solid black; padding: 0cm 5.4pt; width: 15cm;\">\n            <p style=\"margin-bottom: 0.0001pt; line-height: normal;\" class=\"MsoNormal\"><span style=\"font-size: 10pt; font-family: &quot;Courier New&quot;; color: blue;\">DELETE<\/span><span style=\"font-size: 10pt; font-family: &quot;Courier New&quot;;\"> <span style=\"color: blue;\">FROM<\/span> tablo_ismi <o:p><\/o:p><\/span><\/p>\n            <p style=\"margin-bottom: 0.0001pt; line-height: normal;\" class=\"MsoNormal\"><span style=\"font-size: 10pt; font-family: &quot;Courier New&quot;; color: blue;\">WHERE<\/span><span style=\"font-size: 10pt; font-family: &quot;Courier New&quot;;\"> sart_tanimlari<\/span><span style=\"font-size: 10pt; font-family: &quot;Segoe UI&quot;,&quot;sans-serif&quot;;\"><o:p><\/o:p><\/span><\/p>\n            <\/td>\n        <\/tr>\n    <\/tbody>\n<\/table>\n<p class=\"MsoNormal\"><span style=\"font-size: 10pt; line-height: 115%; font-family: &quot;Segoe UI&quot;,&quot;sans-serif&quot;;\"><o:p>&nbsp;<\/o:p><\/span><\/p>","protected":false},"excerpt":{"rendered":"<p>Veri  isleme dili (DML), tablolarimizda bulunan kayitlar &#252;zerinde islemler yapmamizi saglayan ifadeler b&#252;t&#252;n&#252;d&#252;r. Yeni bir kayit eklemek i&#231;in INSERT, bir kaydin silinmesi i&#231;in DELETE, bir kaydin g&#252;ncellenmesi i&#231;inse UPDATE, Okunmasi i&#231;inse SELECT olmak &#252;zere toplamda 4 temel ifadeden olusmaktadir.<\/p>\n","protected":false},"author":540,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[422],"tags":[5789,6014,5027,4279,4135,4134,5632],"_links":{"self":[{"href":"https:\/\/www.yazilimmutfagi.com\/index.php\/wp-json\/wp\/v2\/posts\/74"}],"collection":[{"href":"https:\/\/www.yazilimmutfagi.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.yazilimmutfagi.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.yazilimmutfagi.com\/index.php\/wp-json\/wp\/v2\/users\/540"}],"replies":[{"embeddable":true,"href":"https:\/\/www.yazilimmutfagi.com\/index.php\/wp-json\/wp\/v2\/comments?post=74"}],"version-history":[{"count":0,"href":"https:\/\/www.yazilimmutfagi.com\/index.php\/wp-json\/wp\/v2\/posts\/74\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.yazilimmutfagi.com\/index.php\/wp-json\/wp\/v2\/media?parent=74"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.yazilimmutfagi.com\/index.php\/wp-json\/wp\/v2\/categories?post=74"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.yazilimmutfagi.com\/index.php\/wp-json\/wp\/v2\/tags?post=74"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}