{"id":215,"date":"2010-08-14T23:46:38","date_gmt":"2010-08-14T21:46:38","guid":{"rendered":"http:\/\/www.fethimurat.com\/blog\/?p=215"},"modified":"2017-04-16T14:39:58","modified_gmt":"2017-04-16T12:39:58","slug":"fonksiyonlar","status":"publish","type":"post","link":"https:\/\/www.fethimurat.com\/blog\/fonksiyonlar\/","title":{"rendered":"Fonksiyonlar"},"content":{"rendered":"<pre class=\"brush:csharp\">--her \u00e7al\u0131\u015fanan\u0131n ad\u0131n\u0131 soyad\u0131n\u0131 ve ald\u0131\u011f\u0131 toplam sipari\u015f sa\u0131s\u0131n\u0131 listeleyin\r\n\r\nselect e.FirstName +' '+ e.LastName as Calisan,\r\nCOUNT(OrderID) as SiparisSayisi\r\nfrom Employees e\r\njoin Orders o on o.EmployeeID=e.EmployeeID\r\ngroup by e.FirstName +' '+ e.LastName\r\n\r\n--ba\u015fka yol\r\nselect FirstName, LastName,\r\n(\r\n\tselect COUNT(orderID) from Orders\r\n\twhere EmployeeID=e.EmployeeID\r\n)\r\nfrom Employees e\r\n\r\n------------------FONKS\u0130YONLAR-------------------------\r\n--1) SCALAR FUNCTION(TEK DE\u011eER D\u00d6ND\u00dcREN FONKS\u0130YONLAR)\r\ncreate function udf_SiparisSayisi\r\n(\r\n\t@EmpID int \r\n)\r\nreturns int\r\nas\r\nbegin\r\n\tdeclare @toplam int\r\n\tselect @toplam=count(orderID) from orders\r\n\twhere employeeID=@empID\r\n\treturn(@toplam)\r\nend\r\n\r\n--sistem fonksiyonu olmad\u0131\u011f\u0131 i\u00e7in bizim fonksiyonu yazarken \u015femas\u0131n\u0131(dbo) yazmak zorunday\u0131z.\r\nselect FirstName,LastName,dbo.udf_SiparisSayisi(EmployeeID) from Employees\r\n\r\n--Her m\u00fc\u015fterinin sipari\u015flerinde kazan\u0131lan miktar\u0131(par bazl\u0131) ve \u015firket ad\u0131n\u0131 listeleyin.\r\n--miktar i\u00e7in bir udf yaz\u0131n\u0131z.\r\ncreate function udf_ToplamKazanc\r\n(\r\n\t@CustomerID char(5)\r\n)\r\nreturns money\r\nas\r\nbegin\r\n\tdeclare @Toplam money\r\n\tselect @Toplam=sum(UnitPrice*Quantity*(1-Discount))\r\n\tfrom [Order Details] where OrderID in\r\n\t(\r\n\t\tselect OrderID from Orders where CustomerID=@CustomerID\r\n\t)\r\n\treturn(@toplam)\r\nend\r\n\r\nselect CompanyName, dbo.udf_ToplamKazanc(CustomerID) from Customers\r\n\r\n--i\u00e7ine uzun kenar ve k\u0131sa kenar\u0131 parametle olarak alan ve geriye alan donduren udf\r\ncreate function udf_Dikdortgen\r\n(\r\n\t@u int,\r\n\t@k int\r\n)\r\nreturns int\r\nas\r\nbegin\r\n\treturn(@u*@k)\r\nend\r\n\r\nselect dbo.udf_Dikdortgen(2,5)\r\n\r\n--geriye merhaba mesaj\u0131n\u0131 d\u00f6nd\u00fcren fonksiyon\r\n\r\ncreate function udf_Merhaba\r\n(\r\n\t\r\n)\r\nreturns nchar(20)\r\nas\r\nbegin\r\n\treturn ('Merhaba')\r\nend\r\n\r\nselect dbo.udf_Merhaba()<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>&#8211;her \u00e7al\u0131\u015fanan\u0131n ad\u0131n\u0131 soyad\u0131n\u0131 ve ald\u0131\u011f\u0131 toplam sipari\u015f sa\u0131s\u0131n\u0131 listeleyin select e.FirstName +&#8217; &#8216;+ e.LastName as Calisan, COUNT(OrderID) as SiparisSayisi<\/p>\n","protected":false},"author":14,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[51],"tags":[52,36],"class_list":["post-215","post","type-post","status-publish","format-standard","hentry","category-fonksiyonlar","tag-fonksiyon","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>Fonksiyonlar | 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\/fonksiyonlar\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonksiyonlar | F.Murat ALTINI\u015eIK\" \/>\n<meta property=\"og:description\" content=\"--her \u00e7al\u0131\u015fanan\u0131n ad\u0131n\u0131 soyad\u0131n\u0131 ve ald\u0131\u011f\u0131 toplam sipari\u015f sa\u0131s\u0131n\u0131 listeleyin select e.FirstName +&#039; &#039;+ e.LastName as Calisan, COUNT(OrderID) as SiparisSayisi\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.fethimurat.com\/blog\/fonksiyonlar\/\" \/>\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:46:38+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2017-04-16T12:39:58+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=\"1 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.fethimurat.com\/blog\/fonksiyonlar\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.fethimurat.com\/blog\/fonksiyonlar\/\"},\"author\":{\"name\":\"F.Murat ALTINI\u015eIK\",\"@id\":\"https:\/\/www.fethimurat.com\/blog\/#\/schema\/person\/c4b1061d019bd9186e04c11b1094faa2\"},\"headline\":\"Fonksiyonlar\",\"datePublished\":\"2010-08-14T21:46:38+00:00\",\"dateModified\":\"2017-04-16T12:39:58+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.fethimurat.com\/blog\/fonksiyonlar\/\"},\"wordCount\":1,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.fethimurat.com\/blog\/#\/schema\/person\/c4b1061d019bd9186e04c11b1094faa2\"},\"keywords\":[\"fonksiyon\",\"sql\"],\"articleSection\":[\"Fonksiyonlar\"],\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.fethimurat.com\/blog\/fonksiyonlar\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.fethimurat.com\/blog\/fonksiyonlar\/\",\"url\":\"https:\/\/www.fethimurat.com\/blog\/fonksiyonlar\/\",\"name\":\"Fonksiyonlar | F.Murat ALTINI\u015eIK\",\"isPartOf\":{\"@id\":\"https:\/\/www.fethimurat.com\/blog\/#website\"},\"datePublished\":\"2010-08-14T21:46:38+00:00\",\"dateModified\":\"2017-04-16T12:39:58+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.fethimurat.com\/blog\/fonksiyonlar\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.fethimurat.com\/blog\/fonksiyonlar\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.fethimurat.com\/blog\/fonksiyonlar\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ana sayfa\",\"item\":\"https:\/\/www.fethimurat.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Fonksiyonlar\"}]},{\"@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":"Fonksiyonlar | 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\/fonksiyonlar\/","og_locale":"tr_TR","og_type":"article","og_title":"Fonksiyonlar | F.Murat ALTINI\u015eIK","og_description":"--her \u00e7al\u0131\u015fanan\u0131n ad\u0131n\u0131 soyad\u0131n\u0131 ve ald\u0131\u011f\u0131 toplam sipari\u015f sa\u0131s\u0131n\u0131 listeleyin select e.FirstName +' '+ e.LastName as Calisan, COUNT(OrderID) as SiparisSayisi","og_url":"https:\/\/www.fethimurat.com\/blog\/fonksiyonlar\/","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:46:38+00:00","article_modified_time":"2017-04-16T12:39:58+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":"1 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.fethimurat.com\/blog\/fonksiyonlar\/#article","isPartOf":{"@id":"https:\/\/www.fethimurat.com\/blog\/fonksiyonlar\/"},"author":{"name":"F.Murat ALTINI\u015eIK","@id":"https:\/\/www.fethimurat.com\/blog\/#\/schema\/person\/c4b1061d019bd9186e04c11b1094faa2"},"headline":"Fonksiyonlar","datePublished":"2010-08-14T21:46:38+00:00","dateModified":"2017-04-16T12:39:58+00:00","mainEntityOfPage":{"@id":"https:\/\/www.fethimurat.com\/blog\/fonksiyonlar\/"},"wordCount":1,"commentCount":0,"publisher":{"@id":"https:\/\/www.fethimurat.com\/blog\/#\/schema\/person\/c4b1061d019bd9186e04c11b1094faa2"},"keywords":["fonksiyon","sql"],"articleSection":["Fonksiyonlar"],"inLanguage":"tr","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.fethimurat.com\/blog\/fonksiyonlar\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.fethimurat.com\/blog\/fonksiyonlar\/","url":"https:\/\/www.fethimurat.com\/blog\/fonksiyonlar\/","name":"Fonksiyonlar | F.Murat ALTINI\u015eIK","isPartOf":{"@id":"https:\/\/www.fethimurat.com\/blog\/#website"},"datePublished":"2010-08-14T21:46:38+00:00","dateModified":"2017-04-16T12:39:58+00:00","breadcrumb":{"@id":"https:\/\/www.fethimurat.com\/blog\/fonksiyonlar\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.fethimurat.com\/blog\/fonksiyonlar\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.fethimurat.com\/blog\/fonksiyonlar\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ana sayfa","item":"https:\/\/www.fethimurat.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Fonksiyonlar"}]},{"@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\/215","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=215"}],"version-history":[{"count":0,"href":"https:\/\/www.fethimurat.com\/blog\/wp-json\/wp\/v2\/posts\/215\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.fethimurat.com\/blog\/wp-json\/wp\/v2\/media?parent=215"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.fethimurat.com\/blog\/wp-json\/wp\/v2\/categories?post=215"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.fethimurat.com\/blog\/wp-json\/wp\/v2\/tags?post=215"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}