{"id":259,"date":"2010-08-15T23:15:47","date_gmt":"2010-08-15T21:15:47","guid":{"rendered":"http:\/\/www.fethimurat.com\/blog\/?p=259"},"modified":"2017-04-16T17:20:30","modified_gmt":"2017-04-16T14:20:30","slug":"multi-statement-function","status":"publish","type":"post","link":"https:\/\/www.fethimurat.com\/blog\/multi-statement-function\/","title":{"rendered":"Multi Statement Function"},"content":{"rendered":"<pre class=\"brush:csharp\">---Hi\u00e7 olmayan tablo yap\u0131s\u0131n\u0131 geri d\u00f6nd\u00fcrebiliriz.\r\n\r\n\/*\r\n\t\tREZID\t\tREZNO\t\tUCRET\t\tBIRIM\r\n\t\t123\t\t\t123ER\t\t12\t\t\tTL\r\n\t\t345\t\t\t2545AAA\t23\t23\t\t\tUSD\r\n\t\t384\t\t\tDFDASSD\t\t784\t\t\tEURO\r\n\t\t\r\n\t\tSONU\u00c7:\r\n\t\t\r\n\t\tREZNO\t\tTL\t\t\tUSD\t\t\tEURO\r\n\t\t123\t\t\t12\t\t\t-\t\t\t-\r\n\t\t345\t\t\t-\t\t\t23\t\t\t-\r\n\t\t384\t\t\t-\t\t\t-\t\t\t784\r\n*\/\r\n--\u0130lk\u00f6nce tablo olu\u015ftural\u0131m\r\ncreate table Rez\r\n(\r\n\tRezID int Primary key identity(1,1),\r\n\tUcret decimal(5,2),\r\n\tBirim char(4)\r\n)\r\n\r\n--de\u011ferleri girelim\r\ninsert into Rez values(12.34,'TL')\r\ninsert into Rez values(15.27,'USD')\r\ninsert into Rez values(10.05,'EURO')\r\n\r\n--\u015e\u0130MD\u0130 MULTI STATEMENT FUNCTION YARARINI G\u00d6RELIM\r\ncreate function udf_Tablocu()\r\nreturns @tablo table\r\n(\r\n\tRezID int,\r\n\tTL varchar(8),\r\n\tEURO varchar(8),\r\n\tUSD varchar(8)\r\n)\r\nas\r\nbegin\r\n\tdeclare @rezID int\r\n\tdeclare @birim char(4)\r\n\tdeclare @tl varchar(8),@usd varchar(8), @euro varchar(8), @ucret varchar(8)\r\n\t\r\n\tdeclare @id int \r\n\tset @id=1\r\n\t\r\n\tdeclare @maxID int\r\n\tselect @maxID=max(RezID) from Rez\r\n\t\r\n\twhile @id&lt;=@maxID\r\n\tbegin\r\n\t\tselect @rezID=RezID,@birim=Birim,@ucret=cast(Ucret as varchar(8))\r\n\t\tfrom Rez\r\n\t\twhere RezID=@id\r\n\t\t\r\n\t\tif ltrim(rtrim(@birim)) is not null\r\n\t\tbegin\r\n\t\t\tif @birim='TL'\r\n\t\t\tbegin\r\n\t\t\t\tset @tl=@ucret\r\n\t\t\t\tset @usd='-'\r\n\t\t\t\tset @euro='-'\r\n\t\t\tend\r\n\t\t\telse if ltrim(rtrim(@birim))='USD'\r\n\t\t\tbegin\r\n\t\t\t\tset @tl='-'\r\n\t\t\t\tset @usd=@ucret\r\n\t\t\t\tset @euro='-'\r\n\t\t\tend\r\n\t\t\telse if ltrim(rtrim(@birim))='EURO'\r\n\t\t\tbegin\r\n\t\t\t\tset @tl='-'\r\n\t\t\t\tset @usd='-'\r\n\t\t\t\tset @euro=@ucret\r\n\t\t\tend\r\n\t\t\tinsert into @tablo\r\n\t\t\tvalues(@rezID,@tl,@euro,@usd)\r\n\t\tend\r\n\t\tset @id=@id+1\r\n\tend\r\n\treturn\r\nend\r\n\r\nselect * from dbo.udf_Tablocu()<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>&#8212;Hi\u00e7 olmayan tablo yap\u0131s\u0131n\u0131 geri d\u00f6nd\u00fcrebiliriz. \/* REZID REZNO UCRET BIRIM 123 123ER 12 TL 345 2545AAA 23 23 USD<\/p>\n","protected":false},"author":14,"featured_media":463,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[51],"tags":[52,63,36],"class_list":["post-259","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-fonksiyonlar","tag-fonksiyon","tag-multi-statement-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>Multi Statement 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\/multi-statement-function\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Multi Statement Function | F.Murat ALTINI\u015eIK\" \/>\n<meta property=\"og:description\" content=\"---Hi\u00e7 olmayan tablo yap\u0131s\u0131n\u0131 geri d\u00f6nd\u00fcrebiliriz. \/* REZID REZNO UCRET BIRIM 123 123ER 12 TL 345 2545AAA 23 23 USD\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.fethimurat.com\/blog\/multi-statement-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-15T21:15:47+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2017-04-16T14:20:30+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.fethimurat.com\/blog\/wp-content\/uploads\/2010\/08\/10.png\" \/>\n\t<meta property=\"og:image:width\" content=\"580\" \/>\n\t<meta property=\"og:image:height\" content=\"409\" \/>\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\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\/multi-statement-function\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.fethimurat.com\/blog\/multi-statement-function\/\"},\"author\":{\"name\":\"F.Murat ALTINI\u015eIK\",\"@id\":\"https:\/\/www.fethimurat.com\/blog\/#\/schema\/person\/c4b1061d019bd9186e04c11b1094faa2\"},\"headline\":\"Multi Statement Function\",\"datePublished\":\"2010-08-15T21:15:47+00:00\",\"dateModified\":\"2017-04-16T14:20:30+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.fethimurat.com\/blog\/multi-statement-function\/\"},\"wordCount\":3,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.fethimurat.com\/blog\/#\/schema\/person\/c4b1061d019bd9186e04c11b1094faa2\"},\"image\":{\"@id\":\"https:\/\/www.fethimurat.com\/blog\/multi-statement-function\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.fethimurat.com\/blog\/wp-content\/uploads\/2010\/08\/10.png\",\"keywords\":[\"fonksiyon\",\"Multi Statement Function\",\"sql\"],\"articleSection\":[\"Fonksiyonlar\"],\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.fethimurat.com\/blog\/multi-statement-function\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.fethimurat.com\/blog\/multi-statement-function\/\",\"url\":\"https:\/\/www.fethimurat.com\/blog\/multi-statement-function\/\",\"name\":\"Multi Statement Function | F.Murat ALTINI\u015eIK\",\"isPartOf\":{\"@id\":\"https:\/\/www.fethimurat.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.fethimurat.com\/blog\/multi-statement-function\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.fethimurat.com\/blog\/multi-statement-function\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.fethimurat.com\/blog\/wp-content\/uploads\/2010\/08\/10.png\",\"datePublished\":\"2010-08-15T21:15:47+00:00\",\"dateModified\":\"2017-04-16T14:20:30+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.fethimurat.com\/blog\/multi-statement-function\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.fethimurat.com\/blog\/multi-statement-function\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/www.fethimurat.com\/blog\/multi-statement-function\/#primaryimage\",\"url\":\"https:\/\/www.fethimurat.com\/blog\/wp-content\/uploads\/2010\/08\/10.png\",\"contentUrl\":\"https:\/\/www.fethimurat.com\/blog\/wp-content\/uploads\/2010\/08\/10.png\",\"width\":580,\"height\":409},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.fethimurat.com\/blog\/multi-statement-function\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ana sayfa\",\"item\":\"https:\/\/www.fethimurat.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Multi Statement 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":"Multi Statement 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\/multi-statement-function\/","og_locale":"tr_TR","og_type":"article","og_title":"Multi Statement Function | F.Murat ALTINI\u015eIK","og_description":"---Hi\u00e7 olmayan tablo yap\u0131s\u0131n\u0131 geri d\u00f6nd\u00fcrebiliriz. \/* REZID REZNO UCRET BIRIM 123 123ER 12 TL 345 2545AAA 23 23 USD","og_url":"https:\/\/www.fethimurat.com\/blog\/multi-statement-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-15T21:15:47+00:00","article_modified_time":"2017-04-16T14:20:30+00:00","og_image":[{"width":580,"height":409,"url":"https:\/\/www.fethimurat.com\/blog\/wp-content\/uploads\/2010\/08\/10.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","Tahmini okuma s\u00fcresi":"1 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.fethimurat.com\/blog\/multi-statement-function\/#article","isPartOf":{"@id":"https:\/\/www.fethimurat.com\/blog\/multi-statement-function\/"},"author":{"name":"F.Murat ALTINI\u015eIK","@id":"https:\/\/www.fethimurat.com\/blog\/#\/schema\/person\/c4b1061d019bd9186e04c11b1094faa2"},"headline":"Multi Statement Function","datePublished":"2010-08-15T21:15:47+00:00","dateModified":"2017-04-16T14:20:30+00:00","mainEntityOfPage":{"@id":"https:\/\/www.fethimurat.com\/blog\/multi-statement-function\/"},"wordCount":3,"commentCount":0,"publisher":{"@id":"https:\/\/www.fethimurat.com\/blog\/#\/schema\/person\/c4b1061d019bd9186e04c11b1094faa2"},"image":{"@id":"https:\/\/www.fethimurat.com\/blog\/multi-statement-function\/#primaryimage"},"thumbnailUrl":"https:\/\/www.fethimurat.com\/blog\/wp-content\/uploads\/2010\/08\/10.png","keywords":["fonksiyon","Multi Statement Function","sql"],"articleSection":["Fonksiyonlar"],"inLanguage":"tr","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.fethimurat.com\/blog\/multi-statement-function\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.fethimurat.com\/blog\/multi-statement-function\/","url":"https:\/\/www.fethimurat.com\/blog\/multi-statement-function\/","name":"Multi Statement Function | F.Murat ALTINI\u015eIK","isPartOf":{"@id":"https:\/\/www.fethimurat.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.fethimurat.com\/blog\/multi-statement-function\/#primaryimage"},"image":{"@id":"https:\/\/www.fethimurat.com\/blog\/multi-statement-function\/#primaryimage"},"thumbnailUrl":"https:\/\/www.fethimurat.com\/blog\/wp-content\/uploads\/2010\/08\/10.png","datePublished":"2010-08-15T21:15:47+00:00","dateModified":"2017-04-16T14:20:30+00:00","breadcrumb":{"@id":"https:\/\/www.fethimurat.com\/blog\/multi-statement-function\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.fethimurat.com\/blog\/multi-statement-function\/"]}]},{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/www.fethimurat.com\/blog\/multi-statement-function\/#primaryimage","url":"https:\/\/www.fethimurat.com\/blog\/wp-content\/uploads\/2010\/08\/10.png","contentUrl":"https:\/\/www.fethimurat.com\/blog\/wp-content\/uploads\/2010\/08\/10.png","width":580,"height":409},{"@type":"BreadcrumbList","@id":"https:\/\/www.fethimurat.com\/blog\/multi-statement-function\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ana sayfa","item":"https:\/\/www.fethimurat.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Multi Statement 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\/259","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=259"}],"version-history":[{"count":0,"href":"https:\/\/www.fethimurat.com\/blog\/wp-json\/wp\/v2\/posts\/259\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.fethimurat.com\/blog\/wp-json\/wp\/v2\/media\/463"}],"wp:attachment":[{"href":"https:\/\/www.fethimurat.com\/blog\/wp-json\/wp\/v2\/media?parent=259"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.fethimurat.com\/blog\/wp-json\/wp\/v2\/categories?post=259"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.fethimurat.com\/blog\/wp-json\/wp\/v2\/tags?post=259"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}