{"id":211,"date":"2010-08-14T23:43:59","date_gmt":"2010-08-14T21:43:59","guid":{"rendered":"http:\/\/www.fethimurat.com\/blog\/?p=211"},"modified":"2017-04-16T14:40:04","modified_gmt":"2017-04-16T12:40:04","slug":"trigger-2","status":"publish","type":"post","link":"https:\/\/www.fethimurat.com\/blog\/trigger-2\/","title":{"rendered":"Prosedur &#8211; 2"},"content":{"rendered":"<pre class=\"brush:csharp\">--Customers tablosunda id de\u011feri parametre olarak verilen kayd\u0131n CompanyName de\u011ferini g\u00fcncelleyen bir proc yaz\u0131n.\r\n\r\ncreate proc up_MusteriGuncelle\r\n(\r\n\t@CustomerID nchar(5),\r\n\t@CompanyName nvarchar(40)\r\n)\r\nas\r\nupdate Customers set CompanyName=@CompanyName where @CustomerID=CustomerID\r\n\r\n---ALFKI CompanyName'i g\u00fcncelleyelim\r\nexec up_MusteriGuncelle 'ALFKI','Alfred Caglar LTD'\r\nselect * from Customers\r\n\r\n--log tutmak i\u00e7in tablo olu\u015ftural\u0131m\r\ncreate table Kayitlar\r\n(\r\n\tKayitID uniqueidentifier primary key,\r\n\tTarih datetime,\r\n\tDetay varchar(max)\r\n)\r\n\r\n--order details tablosunda de\u011fi\u015fiklikleri kaydedeck bir trigger\r\nalter trigger tg_KayitYap\r\non [Order Details]\r\nfor update\r\nas\r\ndeclare @eskiSiparisID int, @yeniSiparisID int\r\ndeclare @eskiUrunID int, @yeniUrunID int\r\ndeclare @eskiAdet smallint, @yeniAdet smallint\r\nselect @eskiSiparisID=OrderID, @eskiUrunID =ProductID, @eskiAdet= Quantity\r\nfrom deleted\r\nselect @yeniSiparisID=OrderID, @yeniUrunID =ProductID, @yeniAdet= Quantity\r\nfrom inserted\r\ndeclare @bilgi varchar(max)\r\nset @bilgi='Eski kay\u0131t (OrderID: '+cast(@eskiSiparisID as varchar (5))+', ProductID: ' +cast(@eskiUrunID as varchar(3))+',Quantity : '+cast(@eskiAdet as varchar(3))+') Yeni Kay\u0131t(OrderID: '+cast(@yeniSiparisID as varchar (5))+', ProductID: ' +cast(@yeniUrunID as varchar(3))+',Quantity : '+cast(@yeniAdet as varchar(3))+')'\r\ninsert into Kayitlar values (newid(),getdate(),@bilgi)\r\n\r\n--update yapal\u0131m\r\nupdate [Order Details] set Quantity=123 where OrderID=10248 and ProductID=1\r\n\r\n--sonucu g\u00f6relim\r\nselect * from Kayitlar\r\n--sonu\u00e7 \u015fu \u015fekilde olmal\u0131\r\n--Eski kayit (OrderID: 10248, ProductID: 1,Quantity : 2) Yeni Kayit(OrderID: 10248, ProductID: 1,Quantity : 123)<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>&#8211;Customers tablosunda id de\u011feri parametre olarak verilen kayd\u0131n CompanyName de\u011ferini g\u00fcncelleyen bir proc yaz\u0131n. create proc up_MusteriGuncelle ( @CustomerID nchar(5),<\/p>\n","protected":false},"author":14,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[44],"tags":[45,46,36],"class_list":["post-211","post","type-post","status-publish","format-standard","hentry","category-prosedur","tag-procedure","tag-prosedur-2","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>Prosedur - 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\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Prosedur - 2 | F.Murat ALTINI\u015eIK\" \/>\n<meta property=\"og:description\" content=\"--Customers tablosunda id de\u011feri parametre olarak verilen kayd\u0131n CompanyName de\u011ferini g\u00fcncelleyen bir proc yaz\u0131n. create proc up_MusteriGuncelle ( @CustomerID nchar(5),\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.fethimurat.com\/blog\/trigger-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:43:59+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2017-04-16T12:40:04+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\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.fethimurat.com\/blog\/trigger-2\/\"},\"author\":{\"name\":\"F.Murat ALTINI\u015eIK\",\"@id\":\"https:\/\/www.fethimurat.com\/blog\/#\/schema\/person\/c4b1061d019bd9186e04c11b1094faa2\"},\"headline\":\"Prosedur &#8211; 2\",\"datePublished\":\"2010-08-14T21:43:59+00:00\",\"dateModified\":\"2017-04-16T12:40:04+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.fethimurat.com\/blog\/trigger-2\/\"},\"wordCount\":2,\"commentCount\":6599,\"publisher\":{\"@id\":\"https:\/\/www.fethimurat.com\/blog\/#\/schema\/person\/c4b1061d019bd9186e04c11b1094faa2\"},\"keywords\":[\"procedure\",\"prosedur\",\"sql\"],\"articleSection\":[\"Prosedurler\"],\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.fethimurat.com\/blog\/trigger-2\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.fethimurat.com\/blog\/trigger-2\/\",\"url\":\"https:\/\/www.fethimurat.com\/blog\/trigger-2\/\",\"name\":\"Prosedur - 2 | F.Murat ALTINI\u015eIK\",\"isPartOf\":{\"@id\":\"https:\/\/www.fethimurat.com\/blog\/#website\"},\"datePublished\":\"2010-08-14T21:43:59+00:00\",\"dateModified\":\"2017-04-16T12:40:04+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.fethimurat.com\/blog\/trigger-2\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.fethimurat.com\/blog\/trigger-2\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.fethimurat.com\/blog\/trigger-2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ana sayfa\",\"item\":\"https:\/\/www.fethimurat.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Prosedur &#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":"Prosedur - 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\/","og_locale":"tr_TR","og_type":"article","og_title":"Prosedur - 2 | F.Murat ALTINI\u015eIK","og_description":"--Customers tablosunda id de\u011feri parametre olarak verilen kayd\u0131n CompanyName de\u011ferini g\u00fcncelleyen bir proc yaz\u0131n. create proc up_MusteriGuncelle ( @CustomerID nchar(5),","og_url":"https:\/\/www.fethimurat.com\/blog\/trigger-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:43:59+00:00","article_modified_time":"2017-04-16T12:40:04+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\/#article","isPartOf":{"@id":"https:\/\/www.fethimurat.com\/blog\/trigger-2\/"},"author":{"name":"F.Murat ALTINI\u015eIK","@id":"https:\/\/www.fethimurat.com\/blog\/#\/schema\/person\/c4b1061d019bd9186e04c11b1094faa2"},"headline":"Prosedur &#8211; 2","datePublished":"2010-08-14T21:43:59+00:00","dateModified":"2017-04-16T12:40:04+00:00","mainEntityOfPage":{"@id":"https:\/\/www.fethimurat.com\/blog\/trigger-2\/"},"wordCount":2,"commentCount":6599,"publisher":{"@id":"https:\/\/www.fethimurat.com\/blog\/#\/schema\/person\/c4b1061d019bd9186e04c11b1094faa2"},"keywords":["procedure","prosedur","sql"],"articleSection":["Prosedurler"],"inLanguage":"tr","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.fethimurat.com\/blog\/trigger-2\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.fethimurat.com\/blog\/trigger-2\/","url":"https:\/\/www.fethimurat.com\/blog\/trigger-2\/","name":"Prosedur - 2 | F.Murat ALTINI\u015eIK","isPartOf":{"@id":"https:\/\/www.fethimurat.com\/blog\/#website"},"datePublished":"2010-08-14T21:43:59+00:00","dateModified":"2017-04-16T12:40:04+00:00","breadcrumb":{"@id":"https:\/\/www.fethimurat.com\/blog\/trigger-2\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.fethimurat.com\/blog\/trigger-2\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.fethimurat.com\/blog\/trigger-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ana sayfa","item":"https:\/\/www.fethimurat.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Prosedur &#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\/211","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=211"}],"version-history":[{"count":0,"href":"https:\/\/www.fethimurat.com\/blog\/wp-json\/wp\/v2\/posts\/211\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.fethimurat.com\/blog\/wp-json\/wp\/v2\/media?parent=211"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.fethimurat.com\/blog\/wp-json\/wp\/v2\/categories?post=211"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.fethimurat.com\/blog\/wp-json\/wp\/v2\/tags?post=211"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}