{"id":5122,"date":"2016-10-10T07:53:15","date_gmt":"2016-10-10T07:53:15","guid":{"rendered":"http:\/\/www.gencayyildiz.com\/blog\/?p=5122"},"modified":"2016-10-10T07:53:15","modified_gmt":"2016-10-10T07:53:15","slug":"t-sqlde-top-keywordu-ile-update-ve-delete-islemi","status":"publish","type":"post","link":"https:\/\/www.gencayyildiz.com\/blog\/t-sqlde-top-keywordu-ile-update-ve-delete-islemi\/","title":{"rendered":"T-SQL&#8217;de &#8220;Top&#8221; Keyword\u00fc \u0130le Update ve Delete \u0130\u015flemi"},"content":{"rendered":"<div id=\"fb-root\"><\/div>\n<p>T-SQL&#8217;de Update veya Delete sorgular\u0131n\u0131 belli ba\u015fl\u0131 veriler \u00fczerinde \u00e7al\u0131\u015ft\u0131racaksak e\u011fer where komutunu kullan\u0131r\u0131z. Amma velakin bu sorgular\u0131m\u0131z\u0131n etkileyece\u011fi veriler bir filtreleme gerektirmiyorsa, ilklik yahut sonluk gerektiriyorsa &#8220;top&#8221; keyword\u00fcylede bu i\u015flemleri ger\u00e7ekle\u015ftirebiliyoruz.<\/p>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">\r\nDelete Top(300) From OrnekTablo\r\n<\/pre>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">\r\nUpdate Top(300) OrnekTablo Set Kolon1 = 'Y\u0131ld\u0131z'\r\n<\/pre>\n<p>Yukar\u0131daki \u00f6rnek sorgular\u0131 incelerseniz e\u011fer Top(300) ifadesiyle ilk 300 veriyi silme ve g\u00fcncelleme i\u015flemine tabi tutmu\u015f olduk. E\u011fer ki tablomuzdan son 300 veriyi silmek yahut g\u00fcncellemek isteseydik a\u015fa\u011f\u0131daki gibi bir \u00e7al\u0131\u015fma yeterli olacakt\u0131r.<\/p>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">\r\nWith OrnekWith\r\nas\r\n(\r\nSelect Top(300) * from OrnekTablo Order By ID desc\r\n)\r\nDelete from OrnekWith\r\n<\/pre>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">\r\nWith OrnekWith\r\nas\r\n(\r\nSelect Top(300) * from OrnekTablo Order By ID desc\r\n)\r\nUpdate OrnekWith Set Kolon1 = 'Y\u0131ld\u0131z'\r\n<\/pre>\n<p>Sonraki yaz\u0131lar\u0131mda g\u00f6r\u00fc\u015fmek \u00fczere&#8230;<br \/>\n\u0130yi \u00e7al\u0131\u015fmalar&#8230;<\/p>\n<!-- AddThis Advanced Settings generic via filter on the_content --><!-- AddThis Share Buttons generic via filter on the_content -->","protected":false},"excerpt":{"rendered":"<p>T-SQL&#8217;de Update veya Delete sorgular\u0131n\u0131 belli ba\u015fl\u0131 veriler \u00fczerinde \u00e7al\u0131\u015ft\u0131racaksak e\u011fer where komutunu kullan\u0131r\u0131z. Amma velakin bu sorgular\u0131m\u0131z\u0131n etkileyece\u011fi veriler bir filtreleme gerektirmiyorsa, ilklik yahut sonluk gerektiriyorsa &#8220;top&#8221; keyword\u00fcylede bu i\u015flemleri ger\u00e7ekle\u015ftirebiliyoruz. Delete Top(300)&#46;&#46;&#46;<!-- AddThis Advanced Settings generic via filter on get_the_excerpt --><!-- AddThis Share Buttons generic via filter on get_the_excerpt --><\/p>\n","protected":false},"author":1,"featured_media":3415,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1082,1412,22],"tags":[87,461,84,85,86,96],"class_list":["post-5122","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sql-server","category-sql-server-2016","category-veritabani","tag-delete","tag-t-sql","tag-top","tag-transact-sql","tag-update","tag-with"],"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/posts\/5122","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/comments?post=5122"}],"version-history":[{"count":0,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/posts\/5122\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/media\/3415"}],"wp:attachment":[{"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/media?parent=5122"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/categories?post=5122"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/tags?post=5122"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}