{"id":251,"date":"2010-08-15T18:32:45","date_gmt":"2010-08-15T16:32:45","guid":{"rendered":"http:\/\/www.fethimurat.com\/blog\/?p=251"},"modified":"2017-05-19T16:25:05","modified_gmt":"2017-05-19T13:25:05","slug":"scalar-function","status":"publish","type":"post","link":"https:\/\/www.fethimurat.com\/blog\/scalar-function\/","title":{"rendered":"Scalar Function"},"content":{"rendered":"<pre class=\"brush:csharp\">--Hangi \u00e7al\u0131\u015fan\u0131n hangi kategorideki \u00fcr\u00fcnlerin sipari\u015flerinden ne kadar kazand\u0131rd\u0131\u011f\u0131 hesaplayan function yaz\u0131n\u0131z.\r\n\r\ncreate function udf_Hesapla\r\n(\r\n\t@EmployeeID int,\r\n\t@CategoryID int\r\n)\r\nreturns money\r\nas\r\nbegin\r\n\tdeclare @toplam money\r\n\tselect @toplam=SUM(UnitPrice*Quantity)\r\n\tfrom [Order Details]\r\n\twhere OrderID in\r\n\t(\r\n\t\tselect OrderID from Orders\r\n\t\twhere EmployeeID=@EmployeeID\r\n\t)\r\n\tand ProductID in\r\n\t(\r\n\t\tselect ProductID from Products\r\n\t\twhere CategoryID=@CategoryID\r\n\t)\r\n\treturn(@toplam)\r\nend\r\n\r\n--g\u00f6relim\r\nselect dbo.udf_Hesapla(1,1) as Sonuc<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>&#8211;Hangi \u00e7al\u0131\u015fan\u0131n hangi kategorideki \u00fcr\u00fcnlerin sipari\u015flerinden ne kadar kazand\u0131rd\u0131\u011f\u0131 hesaplayan function yaz\u0131n\u0131z. create function udf_Hesapla ( @EmployeeID int, @CategoryID int<\/p>\n","protected":false},"author":14,"featured_media":639,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[51],"tags":[52,61,36],"class_list":["post-251","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-fonksiyonlar","tag-fonksiyon","tag-scalar-function","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>Scalar Function | 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\/scalar-function\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Scalar Function | F.Murat ALTINI\u015eIK\" \/>\n<meta property=\"og:description\" content=\"--Hangi \u00e7al\u0131\u015fan\u0131n hangi kategorideki \u00fcr\u00fcnlerin sipari\u015flerinden ne kadar kazand\u0131rd\u0131\u011f\u0131 hesaplayan function yaz\u0131n\u0131z. create function udf_Hesapla ( @EmployeeID int, @CategoryID int\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.fethimurat.com\/blog\/scalar-function\/\" \/>\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-15T16:32:45+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2017-05-19T13:25:05+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.fethimurat.com\/blog\/wp-content\/uploads\/2010\/08\/scalar.png\" \/>\n\t<meta property=\"og:image:width\" content=\"616\" \/>\n\t<meta property=\"og:image:height\" content=\"396\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\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<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.fethimurat.com\/blog\/scalar-function\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.fethimurat.com\/blog\/scalar-function\/\"},\"author\":{\"name\":\"F.Murat ALTINI\u015eIK\",\"@id\":\"https:\/\/www.fethimurat.com\/blog\/#\/schema\/person\/c4b1061d019bd9186e04c11b1094faa2\"},\"headline\":\"Scalar Function\",\"datePublished\":\"2010-08-15T16:32:45+00:00\",\"dateModified\":\"2017-05-19T13:25:05+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.fethimurat.com\/blog\/scalar-function\/\"},\"wordCount\":2,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.fethimurat.com\/blog\/#\/schema\/person\/c4b1061d019bd9186e04c11b1094faa2\"},\"image\":{\"@id\":\"https:\/\/www.fethimurat.com\/blog\/scalar-function\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.fethimurat.com\/blog\/wp-content\/uploads\/2010\/08\/scalar.png\",\"keywords\":[\"fonksiyon\",\"scalar function\",\"sql\"],\"articleSection\":[\"Fonksiyonlar\"],\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.fethimurat.com\/blog\/scalar-function\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.fethimurat.com\/blog\/scalar-function\/\",\"url\":\"https:\/\/www.fethimurat.com\/blog\/scalar-function\/\",\"name\":\"Scalar Function | F.Murat ALTINI\u015eIK\",\"isPartOf\":{\"@id\":\"https:\/\/www.fethimurat.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.fethimurat.com\/blog\/scalar-function\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.fethimurat.com\/blog\/scalar-function\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.fethimurat.com\/blog\/wp-content\/uploads\/2010\/08\/scalar.png\",\"datePublished\":\"2010-08-15T16:32:45+00:00\",\"dateModified\":\"2017-05-19T13:25:05+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.fethimurat.com\/blog\/scalar-function\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.fethimurat.com\/blog\/scalar-function\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/www.fethimurat.com\/blog\/scalar-function\/#primaryimage\",\"url\":\"https:\/\/www.fethimurat.com\/blog\/wp-content\/uploads\/2010\/08\/scalar.png\",\"contentUrl\":\"https:\/\/www.fethimurat.com\/blog\/wp-content\/uploads\/2010\/08\/scalar.png\",\"width\":616,\"height\":396},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.fethimurat.com\/blog\/scalar-function\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ana sayfa\",\"item\":\"https:\/\/www.fethimurat.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Scalar Function\"}]},{\"@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":"Scalar Function | 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\/scalar-function\/","og_locale":"tr_TR","og_type":"article","og_title":"Scalar Function | F.Murat ALTINI\u015eIK","og_description":"--Hangi \u00e7al\u0131\u015fan\u0131n hangi kategorideki \u00fcr\u00fcnlerin sipari\u015flerinden ne kadar kazand\u0131rd\u0131\u011f\u0131 hesaplayan function yaz\u0131n\u0131z. create function udf_Hesapla ( @EmployeeID int, @CategoryID int","og_url":"https:\/\/www.fethimurat.com\/blog\/scalar-function\/","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-15T16:32:45+00:00","article_modified_time":"2017-05-19T13:25:05+00:00","og_image":[{"width":616,"height":396,"url":"https:\/\/www.fethimurat.com\/blog\/wp-content\/uploads\/2010\/08\/scalar.png","type":"image\/png"}],"author":"F.Murat ALTINI\u015eIK","twitter_card":"summary_large_image","twitter_creator":"@muratfethi","twitter_site":"@muratfethi","twitter_misc":{"Yazan:":"F.Murat ALTINI\u015eIK"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.fethimurat.com\/blog\/scalar-function\/#article","isPartOf":{"@id":"https:\/\/www.fethimurat.com\/blog\/scalar-function\/"},"author":{"name":"F.Murat ALTINI\u015eIK","@id":"https:\/\/www.fethimurat.com\/blog\/#\/schema\/person\/c4b1061d019bd9186e04c11b1094faa2"},"headline":"Scalar Function","datePublished":"2010-08-15T16:32:45+00:00","dateModified":"2017-05-19T13:25:05+00:00","mainEntityOfPage":{"@id":"https:\/\/www.fethimurat.com\/blog\/scalar-function\/"},"wordCount":2,"commentCount":0,"publisher":{"@id":"https:\/\/www.fethimurat.com\/blog\/#\/schema\/person\/c4b1061d019bd9186e04c11b1094faa2"},"image":{"@id":"https:\/\/www.fethimurat.com\/blog\/scalar-function\/#primaryimage"},"thumbnailUrl":"https:\/\/www.fethimurat.com\/blog\/wp-content\/uploads\/2010\/08\/scalar.png","keywords":["fonksiyon","scalar function","sql"],"articleSection":["Fonksiyonlar"],"inLanguage":"tr","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.fethimurat.com\/blog\/scalar-function\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.fethimurat.com\/blog\/scalar-function\/","url":"https:\/\/www.fethimurat.com\/blog\/scalar-function\/","name":"Scalar Function | F.Murat ALTINI\u015eIK","isPartOf":{"@id":"https:\/\/www.fethimurat.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.fethimurat.com\/blog\/scalar-function\/#primaryimage"},"image":{"@id":"https:\/\/www.fethimurat.com\/blog\/scalar-function\/#primaryimage"},"thumbnailUrl":"https:\/\/www.fethimurat.com\/blog\/wp-content\/uploads\/2010\/08\/scalar.png","datePublished":"2010-08-15T16:32:45+00:00","dateModified":"2017-05-19T13:25:05+00:00","breadcrumb":{"@id":"https:\/\/www.fethimurat.com\/blog\/scalar-function\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.fethimurat.com\/blog\/scalar-function\/"]}]},{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/www.fethimurat.com\/blog\/scalar-function\/#primaryimage","url":"https:\/\/www.fethimurat.com\/blog\/wp-content\/uploads\/2010\/08\/scalar.png","contentUrl":"https:\/\/www.fethimurat.com\/blog\/wp-content\/uploads\/2010\/08\/scalar.png","width":616,"height":396},{"@type":"BreadcrumbList","@id":"https:\/\/www.fethimurat.com\/blog\/scalar-function\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ana sayfa","item":"https:\/\/www.fethimurat.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Scalar Function"}]},{"@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\/251","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=251"}],"version-history":[{"count":0,"href":"https:\/\/www.fethimurat.com\/blog\/wp-json\/wp\/v2\/posts\/251\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.fethimurat.com\/blog\/wp-json\/wp\/v2\/media\/639"}],"wp:attachment":[{"href":"https:\/\/www.fethimurat.com\/blog\/wp-json\/wp\/v2\/media?parent=251"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.fethimurat.com\/blog\/wp-json\/wp\/v2\/categories?post=251"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.fethimurat.com\/blog\/wp-json\/wp\/v2\/tags?post=251"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}