{"id":263,"date":"2010-08-17T20:53:14","date_gmt":"2010-08-17T18:53:14","guid":{"rendered":"http:\/\/www.fethimurat.com\/blog\/?p=263"},"modified":"2017-04-16T17:19:00","modified_gmt":"2017-04-16T14:19:00","slug":"15-08-2010-odev-1","status":"publish","type":"post","link":"https:\/\/www.fethimurat.com\/blog\/15-08-2010-odev-1\/","title":{"rendered":"15.08.2010 \u00d6dev-1"},"content":{"rendered":"<pre class=\"brush:csharp\">-- NorthWind Tablosu i\u00e7in \u00c7al\u0131\u015fan tablosuna \u00e7al\u0131\u015fan\u0131n ad\u0131n\u0131 soyad\u0131n\u0131 parametre olarak, i\u015fe ba\u015flang\u0131\u00e7 tarihi ise i\u015flemin yap\u0131ld\u0131\u011f\u0131 an olarak kay\u0131t yapan procu geriye ka\u00e7 saniye \u00f6nce i\u015fe ba\u015flad\u0131\u011f\u0131n\u0131 d\u00f6ndrecek \u015fekilde yaz\u0131n\u0131z.\r\n\r\ncreate proc up_CalisanEkle\r\n(\r\n  @FirstName varchar(15),\r\n  @LastName varchar(15)\r\n)\r\nas\r\ninsert into Employees(FirstName,LastName,HireDate)\r\nvalues(@FirstName,@LastName,GETDATE())\r\nreturn select datediff(ss,(select HireDate from Employees),GetDate())\r\n\r\ndeclare @ss int\r\nexec @ss=up_CalisanEkle 'caglar1','temur'\r\nselect @ss<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>&#8212; NorthWind Tablosu i\u00e7in \u00c7al\u0131\u015fan tablosuna \u00e7al\u0131\u015fan\u0131n ad\u0131n\u0131 soyad\u0131n\u0131 parametre olarak, i\u015fe ba\u015flang\u0131\u00e7 tarihi ise i\u015flemin yap\u0131ld\u0131\u011f\u0131 an olarak kay\u0131t<\/p>\n","protected":false},"author":14,"featured_media":461,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[65],"tags":[],"class_list":["post-263","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-odevler","comments-off"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>15.08.2010 \u00d6dev-1 | 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\/15-08-2010-odev-1\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"15.08.2010 \u00d6dev-1 | F.Murat ALTINI\u015eIK\" \/>\n<meta property=\"og:description\" content=\"-- NorthWind Tablosu i\u00e7in \u00c7al\u0131\u015fan tablosuna \u00e7al\u0131\u015fan\u0131n ad\u0131n\u0131 soyad\u0131n\u0131 parametre olarak, i\u015fe ba\u015flang\u0131\u00e7 tarihi ise i\u015flemin yap\u0131ld\u0131\u011f\u0131 an olarak kay\u0131t\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.fethimurat.com\/blog\/15-08-2010-odev-1\/\" \/>\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-17T18:53:14+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2017-04-16T14:19:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.fethimurat.com\/blog\/wp-content\/uploads\/2010\/08\/8.png\" \/>\n\t<meta property=\"og:image:width\" content=\"618\" \/>\n\t<meta property=\"og:image:height\" content=\"414\" \/>\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\/15-08-2010-odev-1\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.fethimurat.com\/blog\/15-08-2010-odev-1\/\"},\"author\":{\"name\":\"F.Murat ALTINI\u015eIK\",\"@id\":\"https:\/\/www.fethimurat.com\/blog\/#\/schema\/person\/c4b1061d019bd9186e04c11b1094faa2\"},\"headline\":\"15.08.2010 \u00d6dev-1\",\"datePublished\":\"2010-08-17T18:53:14+00:00\",\"dateModified\":\"2017-04-16T14:19:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.fethimurat.com\/blog\/15-08-2010-odev-1\/\"},\"wordCount\":1,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.fethimurat.com\/blog\/#\/schema\/person\/c4b1061d019bd9186e04c11b1094faa2\"},\"image\":{\"@id\":\"https:\/\/www.fethimurat.com\/blog\/15-08-2010-odev-1\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.fethimurat.com\/blog\/wp-content\/uploads\/2010\/08\/8.png\",\"articleSection\":[\"\u00d6devler\"],\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.fethimurat.com\/blog\/15-08-2010-odev-1\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.fethimurat.com\/blog\/15-08-2010-odev-1\/\",\"url\":\"https:\/\/www.fethimurat.com\/blog\/15-08-2010-odev-1\/\",\"name\":\"15.08.2010 \u00d6dev-1 | F.Murat ALTINI\u015eIK\",\"isPartOf\":{\"@id\":\"https:\/\/www.fethimurat.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.fethimurat.com\/blog\/15-08-2010-odev-1\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.fethimurat.com\/blog\/15-08-2010-odev-1\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.fethimurat.com\/blog\/wp-content\/uploads\/2010\/08\/8.png\",\"datePublished\":\"2010-08-17T18:53:14+00:00\",\"dateModified\":\"2017-04-16T14:19:00+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.fethimurat.com\/blog\/15-08-2010-odev-1\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.fethimurat.com\/blog\/15-08-2010-odev-1\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/www.fethimurat.com\/blog\/15-08-2010-odev-1\/#primaryimage\",\"url\":\"https:\/\/www.fethimurat.com\/blog\/wp-content\/uploads\/2010\/08\/8.png\",\"contentUrl\":\"https:\/\/www.fethimurat.com\/blog\/wp-content\/uploads\/2010\/08\/8.png\",\"width\":618,\"height\":414},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.fethimurat.com\/blog\/15-08-2010-odev-1\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ana sayfa\",\"item\":\"https:\/\/www.fethimurat.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"15.08.2010 \u00d6dev-1\"}]},{\"@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":"15.08.2010 \u00d6dev-1 | 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\/15-08-2010-odev-1\/","og_locale":"tr_TR","og_type":"article","og_title":"15.08.2010 \u00d6dev-1 | F.Murat ALTINI\u015eIK","og_description":"-- NorthWind Tablosu i\u00e7in \u00c7al\u0131\u015fan tablosuna \u00e7al\u0131\u015fan\u0131n ad\u0131n\u0131 soyad\u0131n\u0131 parametre olarak, i\u015fe ba\u015flang\u0131\u00e7 tarihi ise i\u015flemin yap\u0131ld\u0131\u011f\u0131 an olarak kay\u0131t","og_url":"https:\/\/www.fethimurat.com\/blog\/15-08-2010-odev-1\/","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-17T18:53:14+00:00","article_modified_time":"2017-04-16T14:19:00+00:00","og_image":[{"width":618,"height":414,"url":"https:\/\/www.fethimurat.com\/blog\/wp-content\/uploads\/2010\/08\/8.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\/15-08-2010-odev-1\/#article","isPartOf":{"@id":"https:\/\/www.fethimurat.com\/blog\/15-08-2010-odev-1\/"},"author":{"name":"F.Murat ALTINI\u015eIK","@id":"https:\/\/www.fethimurat.com\/blog\/#\/schema\/person\/c4b1061d019bd9186e04c11b1094faa2"},"headline":"15.08.2010 \u00d6dev-1","datePublished":"2010-08-17T18:53:14+00:00","dateModified":"2017-04-16T14:19:00+00:00","mainEntityOfPage":{"@id":"https:\/\/www.fethimurat.com\/blog\/15-08-2010-odev-1\/"},"wordCount":1,"commentCount":0,"publisher":{"@id":"https:\/\/www.fethimurat.com\/blog\/#\/schema\/person\/c4b1061d019bd9186e04c11b1094faa2"},"image":{"@id":"https:\/\/www.fethimurat.com\/blog\/15-08-2010-odev-1\/#primaryimage"},"thumbnailUrl":"https:\/\/www.fethimurat.com\/blog\/wp-content\/uploads\/2010\/08\/8.png","articleSection":["\u00d6devler"],"inLanguage":"tr","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.fethimurat.com\/blog\/15-08-2010-odev-1\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.fethimurat.com\/blog\/15-08-2010-odev-1\/","url":"https:\/\/www.fethimurat.com\/blog\/15-08-2010-odev-1\/","name":"15.08.2010 \u00d6dev-1 | F.Murat ALTINI\u015eIK","isPartOf":{"@id":"https:\/\/www.fethimurat.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.fethimurat.com\/blog\/15-08-2010-odev-1\/#primaryimage"},"image":{"@id":"https:\/\/www.fethimurat.com\/blog\/15-08-2010-odev-1\/#primaryimage"},"thumbnailUrl":"https:\/\/www.fethimurat.com\/blog\/wp-content\/uploads\/2010\/08\/8.png","datePublished":"2010-08-17T18:53:14+00:00","dateModified":"2017-04-16T14:19:00+00:00","breadcrumb":{"@id":"https:\/\/www.fethimurat.com\/blog\/15-08-2010-odev-1\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.fethimurat.com\/blog\/15-08-2010-odev-1\/"]}]},{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/www.fethimurat.com\/blog\/15-08-2010-odev-1\/#primaryimage","url":"https:\/\/www.fethimurat.com\/blog\/wp-content\/uploads\/2010\/08\/8.png","contentUrl":"https:\/\/www.fethimurat.com\/blog\/wp-content\/uploads\/2010\/08\/8.png","width":618,"height":414},{"@type":"BreadcrumbList","@id":"https:\/\/www.fethimurat.com\/blog\/15-08-2010-odev-1\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ana sayfa","item":"https:\/\/www.fethimurat.com\/blog\/"},{"@type":"ListItem","position":2,"name":"15.08.2010 \u00d6dev-1"}]},{"@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\/263","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=263"}],"version-history":[{"count":0,"href":"https:\/\/www.fethimurat.com\/blog\/wp-json\/wp\/v2\/posts\/263\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.fethimurat.com\/blog\/wp-json\/wp\/v2\/media\/461"}],"wp:attachment":[{"href":"https:\/\/www.fethimurat.com\/blog\/wp-json\/wp\/v2\/media?parent=263"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.fethimurat.com\/blog\/wp-json\/wp\/v2\/categories?post=263"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.fethimurat.com\/blog\/wp-json\/wp\/v2\/tags?post=263"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}