{"id":182,"date":"2010-08-14T23:18:19","date_gmt":"2010-08-14T21:18:19","guid":{"rendered":"http:\/\/www.fethimurat.com\/blog\/?p=182"},"modified":"2017-04-16T14:40:48","modified_gmt":"2017-04-16T12:40:48","slug":"dml-baslangic","status":"publish","type":"post","link":"https:\/\/www.fethimurat.com\/blog\/dml-baslangic\/","title":{"rendered":"DML Ba\u015flang\u0131\u00e7"},"content":{"rendered":"<p style=\"font-family: Arial, Helvetica, sans-serif;\">Bu yaz\u0131 ile ilgili SirketDB dosyas\u0131n\u0131 indirip Restore etmeyi unutmay\u0131n\u0131z.<br \/>\n<a href=\"http:\/\/www.fethimurat.com\/blog\/wp-content\/uploads\/2010\/08\/SirketDB.zip\">http:\/\/www.fethimurat.com\/blog\/wp-content\/uploads\/2010\/08\/SirketDB.zip<\/a><\/p>\n<pre class=\"brush:sql\">-- dml (data manuplation language)\r\n-- insert =&gt; ekle\r\n-- delete =&gt; siler\r\n-- upate  =&gt; g\u00fcncelle\r\n-- select =&gt; okumak\r\n\r\n-- departman ekleyelim (yorum sat\u0131r\u0131)\r\ninsert into Departmanlar(Departman)\r\nvalues('Departman1')\r\n\r\n-- personel ekleyelim\r\ninsert into Personeller\r\n(Ad,Soyad,KayitTarihi,Maas,DepartmanID)\r\nvalues('Omer','Beh\u00e7et','10.10.2010',47.54,1)\r\n\r\nselect * from Personeller\r\n\r\n-- sadece ad ve soyad kaydedelim\r\ninsert into Personeller(Soyad,Ad)\r\nvalues ('kabze','hasan')\r\n\r\n-- maas de\u011feri olmayan kay\u0131tlar\u0131n\r\n-- maa\u015f\u0131n\u0131 3 yapal\u0131m(de\u011fer atamas\u0131)\r\n-- veri g\u00fcncellemesi\r\nupdate Personeller set Maas=3\r\nwhere Maas is null\r\n\r\n-- bug\u00fcn ba\u015flay\u0131p yar\u0131n bitecek ve tan\u0131m\u0131 \"yalandan proje\" olacak bir proje kayd\u0131 ekleyiniz...\r\n-- l\u00fctfen projeler tablosuna \u00fcstteki istek i\u00e7in bir insert yaz\u0131n\u0131z\r\ninsert into Projeler\r\nvalues('yalandan proje',GETDATE(),DATEADD(DD,1,GETDATE()))\r\n\r\nselect * from Projeler\r\n\r\n-- ProjeID de\u011feri 1 olan projenin tan\u0131m\u0131n\u0131 \"BilgeAdam projesi\" olarak de\u011fi\u015ftirin\r\nupdate Projeler\r\nset ProjeTanimi='BilgeAdam Projesi'\r\nwhere ProjeID=1\r\n\r\nselect * from Personeller\r\n\r\n-- Personeller tablosunda herhangi bir departmana ba\u011fl\u0131 olmayan personelleri 1 nol\u00fc departmana ba\u011flay\u0131n\u0131z\r\nupdate Personeller\r\nset DepartmanID=1\r\nwhere DepartmanID is null\r\n\r\n-- Ad de\u011feri Om ile ba\u015flayan personelleri silin\r\n-- format : delete from tablo (varsa) where Falan=deger\r\n\r\ndelete from Personeller\r\nwhere Ad like 'om%'\r\n\r\nselect * from Projeler\r\nselect * from Personeller\r\n\r\n-- Soyad\u0131 ka ile ba\u015flayan personelin ad\u0131n\u0131 getirelm\r\nselect Ad from Personeller\r\nwhere Soyad like 'ka%'\r\n\r\n-- departmanID si 1 olan personelin ad\u0131n\u0131 ve soyad\u0131n\u0131 getirin\r\nselect Ad,soyad from Personeller\r\nwhere DepartmanID=1\r\n\r\n-- Maa\u015f\u0131 500 ile 3000 aras\u0131nda olan personellerin Ad\u0131n\u0131 ve soyad\u0131n\u0131 tek kolon olarak ve maa\u015f\u0131n\u0131 getirin\r\nselect Ad+' '+Soyad, Maas from Personeller\r\n--where Maas&gt;500 and Maas&lt;3000\r\nwhere Maas between 500 and 3000\r\n\r\n-- personeller tablosunda ad\u0131n\u0131n 2. harfi a olan personellerin ad\u0131n\u0131 ve personelID sini getirin\r\nselect\r\ncast(PersonelID as varchar(3))+' '+Ad as 'Personel'\r\nfrom Personeller\r\nwhere Ad like '_a%'\r\n\r\n-- Maa\u015f\u0131 10000 den b\u00fcy\u00fck olan ve departmanID de\u011feri 3 olan personelin ad\u0131n\u0131 maa\u015f\u0131n\u0131 ve departmanID de\u011ferini getirin\r\nselect Ad,Maas,DepartmanID from Personeller\r\nwhere Maas&gt;10000 and DepartmanID=3\r\n\r\n-- yazilim departman\u0131ndaki \u00e7al\u0131\u015fanlar\u0131n ad\u0131n\u0131 ve soyad\u0131n\u0131 listeleyin\r\nselect Ad,Soyad from Personeller\r\nwhere DepartmanID=\r\n(\r\n   select DepartmanID from Departmanlar\r\n   where Departman ='Yazilim'\r\n)\r\n\r\n-- Proje Tan\u0131m\u0131m Bil ile ba\u015flayan projeye ismi il ile ba\u015flayan personeli atay\u0131n\r\ninsert into Personel_Proje\r\nvalues\r\n(\r\n   (\r\n     select ProjeID from Projeler where\r\n     ProjeTanimi like 'Bil%'\r\n   )\r\n   ,\r\n   (\r\n      select PersonelID from Personeller where\r\n      Ad like 'il%'\r\n   )\r\n)\r\n\r\n-- Proje tan\u0131m\u0131 i\u00e7inde \"ada\" ge\u00e7en projelerin proje tan\u0131mlar\u0131n\u0131 ve ba\u015flang\u0131c tarihlerini ve toplam ka\u00e7 g\u00fcn s\u00fcrd\u00fc\u011f\u00fcn\u00fc(datediff) g\u00f6sterin\r\nselect ProjeTanimi,BaslangicTarihi,BitisTarihi,DATEDIFF(dd,BaslangicTarihi,BitisTarihi)\r\nfrom Projeler<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Bu yaz\u0131 ile ilgili SirketDB dosyas\u0131n\u0131 indirip Restore etmeyi unutmay\u0131n\u0131z. http:\/\/www.fethimurat.com\/blog\/wp-content\/uploads\/2010\/08\/SirketDB.zip &#8212; dml (data manuplation language) &#8212; insert =&gt; ekle<\/p>\n","protected":false},"author":14,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[35],"tags":[38,37,36],"class_list":["post-182","post","type-post","status-publish","format-standard","hentry","category-dml","tag-data-manuplation-language","tag-dml-2","tag-sql-2","comments-off"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>DML Ba\u015flang\u0131\u00e7 | F.Murat ALTINI\u015eIK<\/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:\/\/www.fethimurat.com\/blog\/dml-baslangic\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"DML Ba\u015flang\u0131\u00e7 | F.Murat ALTINI\u015eIK\" \/>\n<meta property=\"og:description\" content=\"Bu yaz\u0131 ile ilgili SirketDB dosyas\u0131n\u0131 indirip Restore etmeyi unutmay\u0131n\u0131z. http:\/\/www.fethimurat.com\/blog\/wp-content\/uploads\/2010\/08\/SirketDB.zip -- dml (data manuplation language) -- insert =&gt; ekle\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.fethimurat.com\/blog\/dml-baslangic\/\" \/>\n<meta property=\"og:site_name\" content=\"F.Murat ALTINI\u015eIK\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/muratfethi\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/muratfethi\" \/>\n<meta property=\"article:published_time\" content=\"2010-08-14T21:18:19+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2017-04-16T12:40:48+00:00\" \/>\n<meta name=\"author\" content=\"F.Murat ALTINI\u015eIK\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@muratfethi\" \/>\n<meta name=\"twitter:site\" content=\"@muratfethi\" \/>\n<meta name=\"twitter:label1\" content=\"Yazan:\" \/>\n\t<meta name=\"twitter:data1\" content=\"F.Murat ALTINI\u015eIK\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tahmini okuma s\u00fcresi\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.fethimurat.com\/blog\/dml-baslangic\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.fethimurat.com\/blog\/dml-baslangic\/\"},\"author\":{\"name\":\"F.Murat ALTINI\u015eIK\",\"@id\":\"https:\/\/www.fethimurat.com\/blog\/#\/schema\/person\/c4b1061d019bd9186e04c11b1094faa2\"},\"headline\":\"DML Ba\u015flang\u0131\u00e7\",\"datePublished\":\"2010-08-14T21:18:19+00:00\",\"dateModified\":\"2017-04-16T12:40:48+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.fethimurat.com\/blog\/dml-baslangic\/\"},\"wordCount\":25,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.fethimurat.com\/blog\/#\/schema\/person\/c4b1061d019bd9186e04c11b1094faa2\"},\"keywords\":[\"data manuplation language\",\"dml\",\"sql\"],\"articleSection\":[\"DML\"],\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.fethimurat.com\/blog\/dml-baslangic\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.fethimurat.com\/blog\/dml-baslangic\/\",\"url\":\"https:\/\/www.fethimurat.com\/blog\/dml-baslangic\/\",\"name\":\"DML Ba\u015flang\u0131\u00e7 | F.Murat ALTINI\u015eIK\",\"isPartOf\":{\"@id\":\"https:\/\/www.fethimurat.com\/blog\/#website\"},\"datePublished\":\"2010-08-14T21:18:19+00:00\",\"dateModified\":\"2017-04-16T12:40:48+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.fethimurat.com\/blog\/dml-baslangic\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.fethimurat.com\/blog\/dml-baslangic\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.fethimurat.com\/blog\/dml-baslangic\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ana sayfa\",\"item\":\"https:\/\/www.fethimurat.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"DML Ba\u015flang\u0131\u00e7\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.fethimurat.com\/blog\/#website\",\"url\":\"https:\/\/www.fethimurat.com\/blog\/\",\"name\":\"F.Murat ALTINI\u015eIK\",\"description\":\"HTML | PHP | C# | SQL | ASP.net | Bitcoin\",\"publisher\":{\"@id\":\"https:\/\/www.fethimurat.com\/blog\/#\/schema\/person\/c4b1061d019bd9186e04c11b1094faa2\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.fethimurat.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"tr\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/www.fethimurat.com\/blog\/#\/schema\/person\/c4b1061d019bd9186e04c11b1094faa2\",\"name\":\"F.Murat ALTINI\u015eIK\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/www.fethimurat.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/www.fethimurat.com\/blog\/wp-content\/uploads\/2018\/01\/xxx-150x150.jpg\",\"contentUrl\":\"https:\/\/www.fethimurat.com\/blog\/wp-content\/uploads\/2018\/01\/xxx-150x150.jpg\",\"caption\":\"F.Murat ALTINI\u015eIK\"},\"logo\":{\"@id\":\"https:\/\/www.fethimurat.com\/blog\/#\/schema\/person\/image\/\"},\"description\":\"1973 yilinda Balikesir\u2019de dogdum. Ilkokulu Gazi (Ilk\u00f6gretim) Ilk Okulu, Orta okulu ise Karesi Ortaokulunda okudum. Orta okulda merak sardigim elektronige nihayet elektronik b\u00f6l\u00fcm\u00fcn\u00fc kazanarak dijital elektronik ile giris yaptim. Bilgisayar hobim o zamanlarda herkes gibi Commadore 64'lerle baslayip Amigalar ile devam etti.Amat\u00f6r olarak Clipper programciligi yaptim. Donanim ve network konularinda uzmanlasmaya \u00e7alistim. Webtasarim ile ilgili konularda yaptigim \u00e7alismalardan sonra yazilim olan merakim daha da arti, su an c# ve sql \u00fczerindeki \u00e7alismalarim devam etmektedir. UZMANLIK: - MS Ofis Programlari - Adobe Photoshop - Macromedia Flash, Macromedia Dreamweaver - MS Visual Studio - MSSQL, MYSQL - WAN\/LAN , TCP\/IP, DNS, DHCP , VPN - Active Directory tasarim, kurulum ve y\u00f6netim teknikleri - ISA Server - Windows Server\",\"sameAs\":[\"http:\/\/www.fethimurat.com\",\"https:\/\/www.facebook.com\/muratfethi\",\"https:\/\/www.instagram.com\/muratfethi\/\",\"https:\/\/www.linkedin.com\/in\/murat-altiniik-24119a13a\/\",\"https:\/\/x.com\/muratfethi\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"DML Ba\u015flang\u0131\u00e7 | F.Murat ALTINI\u015eIK","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:\/\/www.fethimurat.com\/blog\/dml-baslangic\/","og_locale":"tr_TR","og_type":"article","og_title":"DML Ba\u015flang\u0131\u00e7 | F.Murat ALTINI\u015eIK","og_description":"Bu yaz\u0131 ile ilgili SirketDB dosyas\u0131n\u0131 indirip Restore etmeyi unutmay\u0131n\u0131z. http:\/\/www.fethimurat.com\/blog\/wp-content\/uploads\/2010\/08\/SirketDB.zip -- dml (data manuplation language) -- insert =&gt; ekle","og_url":"https:\/\/www.fethimurat.com\/blog\/dml-baslangic\/","og_site_name":"F.Murat ALTINI\u015eIK","article_publisher":"https:\/\/www.facebook.com\/muratfethi","article_author":"https:\/\/www.facebook.com\/muratfethi","article_published_time":"2010-08-14T21:18:19+00:00","article_modified_time":"2017-04-16T12:40:48+00:00","author":"F.Murat ALTINI\u015eIK","twitter_card":"summary_large_image","twitter_creator":"@muratfethi","twitter_site":"@muratfethi","twitter_misc":{"Yazan:":"F.Murat ALTINI\u015eIK","Tahmini okuma s\u00fcresi":"2 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.fethimurat.com\/blog\/dml-baslangic\/#article","isPartOf":{"@id":"https:\/\/www.fethimurat.com\/blog\/dml-baslangic\/"},"author":{"name":"F.Murat ALTINI\u015eIK","@id":"https:\/\/www.fethimurat.com\/blog\/#\/schema\/person\/c4b1061d019bd9186e04c11b1094faa2"},"headline":"DML Ba\u015flang\u0131\u00e7","datePublished":"2010-08-14T21:18:19+00:00","dateModified":"2017-04-16T12:40:48+00:00","mainEntityOfPage":{"@id":"https:\/\/www.fethimurat.com\/blog\/dml-baslangic\/"},"wordCount":25,"commentCount":0,"publisher":{"@id":"https:\/\/www.fethimurat.com\/blog\/#\/schema\/person\/c4b1061d019bd9186e04c11b1094faa2"},"keywords":["data manuplation language","dml","sql"],"articleSection":["DML"],"inLanguage":"tr","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.fethimurat.com\/blog\/dml-baslangic\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.fethimurat.com\/blog\/dml-baslangic\/","url":"https:\/\/www.fethimurat.com\/blog\/dml-baslangic\/","name":"DML Ba\u015flang\u0131\u00e7 | F.Murat ALTINI\u015eIK","isPartOf":{"@id":"https:\/\/www.fethimurat.com\/blog\/#website"},"datePublished":"2010-08-14T21:18:19+00:00","dateModified":"2017-04-16T12:40:48+00:00","breadcrumb":{"@id":"https:\/\/www.fethimurat.com\/blog\/dml-baslangic\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.fethimurat.com\/blog\/dml-baslangic\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.fethimurat.com\/blog\/dml-baslangic\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ana sayfa","item":"https:\/\/www.fethimurat.com\/blog\/"},{"@type":"ListItem","position":2,"name":"DML Ba\u015flang\u0131\u00e7"}]},{"@type":"WebSite","@id":"https:\/\/www.fethimurat.com\/blog\/#website","url":"https:\/\/www.fethimurat.com\/blog\/","name":"F.Murat ALTINI\u015eIK","description":"HTML | PHP | C# | SQL | ASP.net | Bitcoin","publisher":{"@id":"https:\/\/www.fethimurat.com\/blog\/#\/schema\/person\/c4b1061d019bd9186e04c11b1094faa2"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.fethimurat.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"tr"},{"@type":["Person","Organization"],"@id":"https:\/\/www.fethimurat.com\/blog\/#\/schema\/person\/c4b1061d019bd9186e04c11b1094faa2","name":"F.Murat ALTINI\u015eIK","image":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/www.fethimurat.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/www.fethimurat.com\/blog\/wp-content\/uploads\/2018\/01\/xxx-150x150.jpg","contentUrl":"https:\/\/www.fethimurat.com\/blog\/wp-content\/uploads\/2018\/01\/xxx-150x150.jpg","caption":"F.Murat ALTINI\u015eIK"},"logo":{"@id":"https:\/\/www.fethimurat.com\/blog\/#\/schema\/person\/image\/"},"description":"1973 yilinda Balikesir\u2019de dogdum. Ilkokulu Gazi (Ilk\u00f6gretim) Ilk Okulu, Orta okulu ise Karesi Ortaokulunda okudum. Orta okulda merak sardigim elektronige nihayet elektronik b\u00f6l\u00fcm\u00fcn\u00fc kazanarak dijital elektronik ile giris yaptim. Bilgisayar hobim o zamanlarda herkes gibi Commadore 64'lerle baslayip Amigalar ile devam etti.Amat\u00f6r olarak Clipper programciligi yaptim. Donanim ve network konularinda uzmanlasmaya \u00e7alistim. Webtasarim ile ilgili konularda yaptigim \u00e7alismalardan sonra yazilim olan merakim daha da arti, su an c# ve sql \u00fczerindeki \u00e7alismalarim devam etmektedir. UZMANLIK: - MS Ofis Programlari - Adobe Photoshop - Macromedia Flash, Macromedia Dreamweaver - MS Visual Studio - MSSQL, MYSQL - WAN\/LAN , TCP\/IP, DNS, DHCP , VPN - Active Directory tasarim, kurulum ve y\u00f6netim teknikleri - ISA Server - Windows Server","sameAs":["http:\/\/www.fethimurat.com","https:\/\/www.facebook.com\/muratfethi","https:\/\/www.instagram.com\/muratfethi\/","https:\/\/www.linkedin.com\/in\/murat-altiniik-24119a13a\/","https:\/\/x.com\/muratfethi"]}]}},"_links":{"self":[{"href":"https:\/\/www.fethimurat.com\/blog\/wp-json\/wp\/v2\/posts\/182","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.fethimurat.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.fethimurat.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.fethimurat.com\/blog\/wp-json\/wp\/v2\/users\/14"}],"replies":[{"embeddable":true,"href":"https:\/\/www.fethimurat.com\/blog\/wp-json\/wp\/v2\/comments?post=182"}],"version-history":[{"count":0,"href":"https:\/\/www.fethimurat.com\/blog\/wp-json\/wp\/v2\/posts\/182\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.fethimurat.com\/blog\/wp-json\/wp\/v2\/media?parent=182"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.fethimurat.com\/blog\/wp-json\/wp\/v2\/categories?post=182"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.fethimurat.com\/blog\/wp-json\/wp\/v2\/tags?post=182"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}