{"id":217,"date":"2010-08-14T23:47:15","date_gmt":"2010-08-14T21:47:15","guid":{"rendered":"http:\/\/www.fethimurat.com\/blog\/?p=217"},"modified":"2017-04-16T14:39:47","modified_gmt":"2017-04-16T12:39:47","slug":"trigger-2-2","status":"publish","type":"post","link":"https:\/\/www.fethimurat.com\/blog\/trigger-2-2\/","title":{"rendered":"Trigger &#8211; 2"},"content":{"rendered":"<pre class=\"brush:csharp\">--\u00dcr\u00fcn kayd\u0131 silinmesini engelleyecek ve d\u0131\u015far\u0131 silemessin yazd\u0131racak trigger\r\ncreate trigger tg_UrunlerSilinmesin\r\non Products\r\ninstead of delete\r\nas\r\nselect 'Silemessin'\r\n\r\ndelete from products where productID=1\r\n\r\n--Suppliers(Tedarik\u00e7iler) tablosuna Company Name(\u015eirket ad\u0131n\u0131)'i ekleyecek bir proc yaz\u0131n\u0131z.\r\n\r\ncreate proc up_CompanyNameEkle\r\n(\r\n\t@CompanyName varchar(40)\r\n)\r\nas\r\ninsert into Suppliers(CompanyName)\r\nvalues(@CompanyName)\r\n\r\nexec up_CompanyNameEkle 'Hedende LTD'\r\n\r\n--T\u00fcm \u00e7al\u0131\u015fanlar\u0131n ad ve soyadlar\u0131n\u0131 getirecek ama e\u011fer soyad\u0131 davolio ise davaro diye getirecek proc\r\n\r\ncreate proc up_CalisanlariGetiriver\r\nas\r\nselect FirstName, case LastName when 'Davolio' then 'Davaro' else\r\nLastName end from Employees\r\n\r\nexec up_CalisanlariGetiriver\r\n\r\ncreate proc up_CalisanlariGetiriver2\r\nas\r\nselect FirstName+' '+ case LastName when 'Davolio' then 'Davaro' else\r\nLastName end from Employees\r\n\r\nexec up_CalisanlariGetiriver2\r\n\r\n--Firstname Nancy ise nazan gelsin\r\ncreate proc up_CalisanlariGetiriver3\r\nas\r\nselect case FirstName when 'Nancy' then 'Nazan'else FirstName end,\r\ncase LastName when 'Davolio' then 'Davaro' else\r\nLastName end from Employees\r\n\r\nexec up_CalisanlariGetiriver3\r\n\r\n--yukar\u0131daki proc un d\u00f6nd\u00fcrd\u00fc\u011f\u00fc sonu\u00e7 k\u00fcmesinde soyad\u0131nda 'er' bulunan kay\u0131tlar\u0131 getirin...\r\n\r\n--cevap bir procun geriye d\u00f6nd\u00fcrd\u00fc\u011f\u00fc k\u00fcmede \u015fart aranmaz. B\u00f6yle bir sorunun cevab\u0131 yoktur.\r\n\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>&#8211;\u00dcr\u00fcn kayd\u0131 silinmesini engelleyecek ve d\u0131\u015far\u0131 silemessin yazd\u0131racak trigger create trigger tg_UrunlerSilinmesin on Products instead of delete as select &#8216;Silemessin&#8217;<\/p>\n","protected":false},"author":14,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[47],"tags":[36,48],"class_list":["post-217","post","type-post","status-publish","format-standard","hentry","category-trigger","tag-sql-2","tag-trigger-2","comments-off"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Trigger - 2 | 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\/trigger-2-2\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Trigger - 2 | F.Murat ALTINI\u015eIK\" \/>\n<meta property=\"og:description\" content=\"--\u00dcr\u00fcn kayd\u0131 silinmesini engelleyecek ve d\u0131\u015far\u0131 silemessin yazd\u0131racak trigger create trigger tg_UrunlerSilinmesin on Products instead of delete as select &#039;Silemessin&#039;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.fethimurat.com\/blog\/trigger-2-2\/\" \/>\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:47:15+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2017-04-16T12:39:47+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\/trigger-2-2\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.fethimurat.com\/blog\/trigger-2-2\/\"},\"author\":{\"name\":\"F.Murat ALTINI\u015eIK\",\"@id\":\"https:\/\/www.fethimurat.com\/blog\/#\/schema\/person\/c4b1061d019bd9186e04c11b1094faa2\"},\"headline\":\"Trigger &#8211; 2\",\"datePublished\":\"2010-08-14T21:47:15+00:00\",\"dateModified\":\"2017-04-16T12:39:47+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.fethimurat.com\/blog\/trigger-2-2\/\"},\"wordCount\":2,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.fethimurat.com\/blog\/#\/schema\/person\/c4b1061d019bd9186e04c11b1094faa2\"},\"keywords\":[\"sql\",\"trigger\"],\"articleSection\":[\"Trigger\"],\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.fethimurat.com\/blog\/trigger-2-2\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.fethimurat.com\/blog\/trigger-2-2\/\",\"url\":\"https:\/\/www.fethimurat.com\/blog\/trigger-2-2\/\",\"name\":\"Trigger - 2 | F.Murat ALTINI\u015eIK\",\"isPartOf\":{\"@id\":\"https:\/\/www.fethimurat.com\/blog\/#website\"},\"datePublished\":\"2010-08-14T21:47:15+00:00\",\"dateModified\":\"2017-04-16T12:39:47+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.fethimurat.com\/blog\/trigger-2-2\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.fethimurat.com\/blog\/trigger-2-2\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.fethimurat.com\/blog\/trigger-2-2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ana sayfa\",\"item\":\"https:\/\/www.fethimurat.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Trigger &#8211; 2\"}]},{\"@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":"Trigger - 2 | 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\/trigger-2-2\/","og_locale":"tr_TR","og_type":"article","og_title":"Trigger - 2 | F.Murat ALTINI\u015eIK","og_description":"--\u00dcr\u00fcn kayd\u0131 silinmesini engelleyecek ve d\u0131\u015far\u0131 silemessin yazd\u0131racak trigger create trigger tg_UrunlerSilinmesin on Products instead of delete as select 'Silemessin'","og_url":"https:\/\/www.fethimurat.com\/blog\/trigger-2-2\/","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:47:15+00:00","article_modified_time":"2017-04-16T12:39:47+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\/trigger-2-2\/#article","isPartOf":{"@id":"https:\/\/www.fethimurat.com\/blog\/trigger-2-2\/"},"author":{"name":"F.Murat ALTINI\u015eIK","@id":"https:\/\/www.fethimurat.com\/blog\/#\/schema\/person\/c4b1061d019bd9186e04c11b1094faa2"},"headline":"Trigger &#8211; 2","datePublished":"2010-08-14T21:47:15+00:00","dateModified":"2017-04-16T12:39:47+00:00","mainEntityOfPage":{"@id":"https:\/\/www.fethimurat.com\/blog\/trigger-2-2\/"},"wordCount":2,"commentCount":0,"publisher":{"@id":"https:\/\/www.fethimurat.com\/blog\/#\/schema\/person\/c4b1061d019bd9186e04c11b1094faa2"},"keywords":["sql","trigger"],"articleSection":["Trigger"],"inLanguage":"tr","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.fethimurat.com\/blog\/trigger-2-2\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.fethimurat.com\/blog\/trigger-2-2\/","url":"https:\/\/www.fethimurat.com\/blog\/trigger-2-2\/","name":"Trigger - 2 | F.Murat ALTINI\u015eIK","isPartOf":{"@id":"https:\/\/www.fethimurat.com\/blog\/#website"},"datePublished":"2010-08-14T21:47:15+00:00","dateModified":"2017-04-16T12:39:47+00:00","breadcrumb":{"@id":"https:\/\/www.fethimurat.com\/blog\/trigger-2-2\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.fethimurat.com\/blog\/trigger-2-2\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.fethimurat.com\/blog\/trigger-2-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ana sayfa","item":"https:\/\/www.fethimurat.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Trigger &#8211; 2"}]},{"@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\/217","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=217"}],"version-history":[{"count":0,"href":"https:\/\/www.fethimurat.com\/blog\/wp-json\/wp\/v2\/posts\/217\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.fethimurat.com\/blog\/wp-json\/wp\/v2\/media?parent=217"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.fethimurat.com\/blog\/wp-json\/wp\/v2\/categories?post=217"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.fethimurat.com\/blog\/wp-json\/wp\/v2\/tags?post=217"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}