{"id":207,"date":"2010-08-14T23:41:56","date_gmt":"2010-08-14T21:41:56","guid":{"rendered":"http:\/\/www.fethimurat.com\/blog\/?p=207"},"modified":"2017-04-16T14:40:16","modified_gmt":"2017-04-16T12:40:16","slug":"trigger","status":"publish","type":"post","link":"https:\/\/www.fethimurat.com\/blog\/trigger\/","title":{"rendered":"Trigger"},"content":{"rendered":"<pre class=\"brush:csharp\">-----------------TRIGGER---------------------------\r\n\r\n\/*\r\n\tTrigger=&gt;Tetikleyici\r\n\t\tdml\r\n\t\t\tfor(after)\r\n\t\t\tinstead of(yerine)\r\n\t\tdll\r\n*\/\r\n\r\n-- Yeni bir lategori eklendi\u011finde yeni kategori eklendi mesaj\u0131n\u0131 veren bir trigger yazal\u0131m\r\ncreate trigger tg_YeniKategoriEklendi\r\non categories\r\nfor insert\r\nas\r\nselect 'Yeni kategori Eklendi'\r\n\r\n--Kategori ekleip sonuca bakal\u0131m\r\ninsert into Categories(CategoryName)\r\nvalues ('KatKat')\r\n\r\n--Cal\u0131sanlar tablosunda yap\u0131lan insertte eklenen \u00e7al\u0131\u015fan\u0131n ad ve soyad bilgilerinin listeleyen bir trigger\r\ncreate trigger tg_CalisanEklendi\r\non Employees\r\nfor insert\r\nas\r\nselect FirstName,LastName\r\nfrom inserted --inserted eklenen kayd\u0131n bilgilerini tutan tablo veri tipi ntext olanlar\u0131 \u00e7ekemeyiz.\r\n\r\ninsert into Employees(FirstName,LastName,Title)\r\nvalues ('Ilkkan','Acikgoz','Akademisyen')\r\n\r\n--Kategoriler tablosundan silinen kayd\u0131n ID de\u011ferini ekrana yazd\u0131racak bir trigger.\r\ncreate trigger tg_KayitSilindi\r\non Categories\r\nfor delete\r\nas\r\nselect CategoryID\r\nfrom deleted\r\n\r\ndelete from Categories where categoryID=11\r\n\r\n--Categories tablosunda bir update i\u015flemi meyadana geldi\u011finde CategoryName kolunun eski ve yeni bilhigini ekrana yazd\u0131r\u0131n\u0131z.\r\ncreate trigger tg_KategoriUpdateEdildi\r\non Categories\r\nfor update\r\nas\r\ndeclare @eski varchar(15),@yeni varchar(15)\r\nselect @eski=CategoryName from deleted\r\nselect @yeni=CategoryName from inserted\r\ndeclare @bilgi varchar(70)\r\nset @bilgi='Eski ad\u0131 '+@eski+' olan Kategorinin yeni ad\u0131 '+@yeni+' oldu.'\r\nselect @bilgi\r\n\r\n--update i\u015flemi yapal\u0131m\r\nupdate Categories set CategoryName='TgCi Kat' where CategoryID=10\r\n\r\n--\u0130nstead of trigger haz\u0131rl\u0131k\r\n--\u00f6nce \u00e7al\u0131\u015fan tablosuna kolon ekleyelim\r\nalter table Employees\r\nadd SilindiMi bit\r\n\r\n--t\u00fcm \u00e7al\u0131\u015fanlar\u0131n silindi mi de\u011ferlerini fals yapal\u0131m\r\nupdate Employees set SilindiMi=0\r\n\r\n-- uygulamalar\u0131n kullanaca\u011f\u0131 t\u00fcm \u00e7al\u0131\u015fanlar\u0131n ad ve soyadlar\u0131n\u0131 ve id de\u011ferlerini getiren bir proc yaz\u0131n\u0131z\r\ncreate proc up_CalisanBilgisiniGetir\r\nas\r\nSelect EmployeeID,FirstName,LastName\r\nfrom Employees where SilindiMi=0\r\n\r\n--patrona y\u0131ll\u0131k rapor sunarken kullan\u0131lacak \u00e7al\u0131\u015fan listesi\r\ncreate proc up_PatronIc\u0131nCalisanGetir\r\nas\r\nselect EmployeeID,FirstName,LastName\r\nfrom Employees\r\n\r\n--\u00c7al\u0131\u015fan kay\u0131tlar\u0131n\u0131n silinmesini engelle\r\ncreate trigger tg_CalisanlarSiliniyor\r\non Employees\r\ninstead of delete  --silinme i\u015flemi yerine \u015funu yap anlam\u0131nda\r\nas\r\ndeclare @silinecekID int\r\nselect @silinecekID=EmployeeID from deleted\r\nupdate Employees set SilindiMi=1\r\nwhere EmployeeID=@silinecekID\r\n\r\n\/*\r\n\t\t\t.mdf\t\t\t\t.ldf\r\n\t\t\t\t\t\t\tinsert=&gt; 1 Caglar\r\n\t\t\t1 Caglar\t\t&lt;=commit(onaylan\u0131rsa)\r\n\t\t\t\t\t\t\tinsert=&gt; 2 Murat\r\n\t\t\t\t\t\t\ttollback(ba\u015fa sar)\r\n\t\t\t\t\t\t\tinsert=&gt; 3 Murat\r\n\t\t\t3 Murat\t\t\t&lt;=commit(onaylan\u0131rsa)\r\n*\/\r\n\r\n--Cal\u0131sanlardan en son eklenen \u00e7al\u0131\u015fan\u0131 silecek komutu yaz\u0131n\u0131z\r\ndelete from Employees where EmployeeID=\r\n(\r\n\tselect max(EmployeeID) from Employees\r\n)\r\n\r\n--Patron rapor istedi\r\nexec up_PatronIc\u0131nCalisanGetir\r\n\r\n--uygulama \u00e7al\u0131\u015fan\u015flar\u0131 \u00e7eksin\r\nexec up_CalisanBilgisiniGetir<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>&#8212;&#8212;&#8212;&#8212;&#8212;&#8211;TRIGGER&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212; \/* Trigger=&gt;Tetikleyici dml for(after) instead of(yerine) dll *\/ &#8212; Yeni bir lategori eklendi\u011finde yeni kategori eklendi mesaj\u0131n\u0131 veren bir<\/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-207","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 | 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\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Trigger | F.Murat ALTINI\u015eIK\" \/>\n<meta property=\"og:description\" content=\"-----------------TRIGGER--------------------------- \/* Trigger=&gt;Tetikleyici dml for(after) instead of(yerine) dll *\/ -- Yeni bir lategori eklendi\u011finde yeni kategori eklendi mesaj\u0131n\u0131 veren bir\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.fethimurat.com\/blog\/trigger\/\" \/>\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:41:56+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2017-04-16T12:40:16+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=\"2 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\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.fethimurat.com\/blog\/trigger\/\"},\"author\":{\"name\":\"F.Murat ALTINI\u015eIK\",\"@id\":\"https:\/\/www.fethimurat.com\/blog\/#\/schema\/person\/c4b1061d019bd9186e04c11b1094faa2\"},\"headline\":\"Trigger\",\"datePublished\":\"2010-08-14T21:41:56+00:00\",\"dateModified\":\"2017-04-16T12:40:16+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.fethimurat.com\/blog\/trigger\/\"},\"wordCount\":1,\"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\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.fethimurat.com\/blog\/trigger\/\",\"url\":\"https:\/\/www.fethimurat.com\/blog\/trigger\/\",\"name\":\"Trigger | F.Murat ALTINI\u015eIK\",\"isPartOf\":{\"@id\":\"https:\/\/www.fethimurat.com\/blog\/#website\"},\"datePublished\":\"2010-08-14T21:41:56+00:00\",\"dateModified\":\"2017-04-16T12:40:16+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.fethimurat.com\/blog\/trigger\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.fethimurat.com\/blog\/trigger\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.fethimurat.com\/blog\/trigger\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ana sayfa\",\"item\":\"https:\/\/www.fethimurat.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Trigger\"}]},{\"@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 | 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\/","og_locale":"tr_TR","og_type":"article","og_title":"Trigger | F.Murat ALTINI\u015eIK","og_description":"-----------------TRIGGER--------------------------- \/* Trigger=&gt;Tetikleyici dml for(after) instead of(yerine) dll *\/ -- Yeni bir lategori eklendi\u011finde yeni kategori eklendi mesaj\u0131n\u0131 veren bir","og_url":"https:\/\/www.fethimurat.com\/blog\/trigger\/","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:41:56+00:00","article_modified_time":"2017-04-16T12:40:16+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":"2 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.fethimurat.com\/blog\/trigger\/#article","isPartOf":{"@id":"https:\/\/www.fethimurat.com\/blog\/trigger\/"},"author":{"name":"F.Murat ALTINI\u015eIK","@id":"https:\/\/www.fethimurat.com\/blog\/#\/schema\/person\/c4b1061d019bd9186e04c11b1094faa2"},"headline":"Trigger","datePublished":"2010-08-14T21:41:56+00:00","dateModified":"2017-04-16T12:40:16+00:00","mainEntityOfPage":{"@id":"https:\/\/www.fethimurat.com\/blog\/trigger\/"},"wordCount":1,"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\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.fethimurat.com\/blog\/trigger\/","url":"https:\/\/www.fethimurat.com\/blog\/trigger\/","name":"Trigger | F.Murat ALTINI\u015eIK","isPartOf":{"@id":"https:\/\/www.fethimurat.com\/blog\/#website"},"datePublished":"2010-08-14T21:41:56+00:00","dateModified":"2017-04-16T12:40:16+00:00","breadcrumb":{"@id":"https:\/\/www.fethimurat.com\/blog\/trigger\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.fethimurat.com\/blog\/trigger\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.fethimurat.com\/blog\/trigger\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ana sayfa","item":"https:\/\/www.fethimurat.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Trigger"}]},{"@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\/207","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=207"}],"version-history":[{"count":0,"href":"https:\/\/www.fethimurat.com\/blog\/wp-json\/wp\/v2\/posts\/207\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.fethimurat.com\/blog\/wp-json\/wp\/v2\/media?parent=207"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.fethimurat.com\/blog\/wp-json\/wp\/v2\/categories?post=207"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.fethimurat.com\/blog\/wp-json\/wp\/v2\/tags?post=207"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}