{"id":901,"date":"2012-10-21T12:31:45","date_gmt":"2012-10-21T12:31:45","guid":{"rendered":"http:\/\/www.gencayyildiz.com\/blog\/?p=901"},"modified":"2012-10-21T12:32:58","modified_gmt":"2012-10-21T12:32:58","slug":"sqlde-en-son-primary-key-id-yi-bulmak","status":"publish","type":"post","link":"https:\/\/www.gencayyildiz.com\/blog\/sqlde-en-son-primary-key-id-yi-bulmak\/","title":{"rendered":"SQL&#8217;de En Son Primary Key ID yi Bulmak"},"content":{"rendered":"<div id=\"fb-root\"><\/div>\n<p>Bazen, veritaban\u0131m\u0131za en son kay\u0131ttan sonra eklenecek verinin Primary Key olarak belirlenmi\u015f ID de\u011ferini \u00f6nceden elde etmek isteyebiliriz.<\/p>\n<p>\u00d6rnek olarak; 1,2 ve 3 IDlerine sahip veri listemizden 3. ID&#8217;li veriyi sildikten sonra eklenen verimizin ID de\u011feri 4 olacakt\u0131r.Bu durumda veri listesi ise 1,2 ve 4 IDlerine sahip verilerden olacakt\u0131r.Bu durumda en son kayd\u0131n ID de\u011ferine +1 ekleme mant\u0131\u011f\u0131n\u0131n ge\u00e7ersiz oldu\u011funu g\u00f6r\u00fcyoruz.<\/p>\n<pre class=\"brush: jscript; title: ; notranslate\" title=\"\">\r\nSElECT IDENT_CURRENT('Oyunlar')\r\n<\/pre>\n<p>Bu kod sayesinde, istedi\u011finiz sat\u0131r\u0131 silin,genede size en son eklenen kayd\u0131n ID sini verecektir.<\/p>\n<pre class=\"brush: jscript; title: ; notranslate\" title=\"\">\r\nSElECT IDENT_CURRENT('Oyunlar') + 1\r\n<\/pre>\n<p>Bu \u015fekilde kullanmam\u0131z ise, en son eklenen kay\u0131ttan sonra eklenecek verinin ID de\u011ferinin ne olaca\u011f\u0131n\u0131 vermektedir.<\/p>\n<p>Faydalanman\u0131z dile\u011fiyle..<\/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>Bazen, veritaban\u0131m\u0131za en son kay\u0131ttan sonra eklenecek verinin Primary Key olarak belirlenmi\u015f ID de\u011ferini \u00f6nceden elde etmek isteyebiliriz. \u00d6rnek olarak; 1,2 ve 3 IDlerine sahip veri listemizden 3. ID&#8217;li veriyi sildikten sonra eklenen verimizin&#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":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[22],"tags":[277,113,85],"class_list":["post-901","post","type-post","status-publish","format-standard","hentry","category-veritabani","tag-id","tag-primary-key","tag-transact-sql"],"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/posts\/901","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=901"}],"version-history":[{"count":0,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/posts\/901\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/media?parent=901"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/categories?post=901"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/tags?post=901"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}