{"id":418,"date":"2025-07-18T14:33:37","date_gmt":"2025-07-18T11:33:37","guid":{"rendered":"https:\/\/www.hasanbirden.com\/blog\/?p=418"},"modified":"2025-07-18T15:08:02","modified_gmt":"2025-07-18T12:08:02","slug":"sql-serverda-id-sutununu-1den-baslatarak-yeniden-siralamak","status":"publish","type":"post","link":"https:\/\/www.hasanbirden.com\/blog\/yazilim\/sql\/sql-serverda-id-sutununu-1den-baslatarak-yeniden-siralamak\/","title":{"rendered":"SQL Server&#8217;da ID S\u00fctununu 1&#8217;den Ba\u015flatarak Yeniden S\u0131ralamak"},"content":{"rendered":"\n<p>Veritabanlar\u0131nda otomatik artan <code>ID<\/code> s\u00fctunu, zamanla silinen kay\u0131tlar veya d\u0131\u015far\u0131dan yap\u0131lan veri giri\u015fleri nedeniyle s\u0131ral\u0131 olmayabilir. \u00d6rne\u011fin, <code>ID<\/code> de\u011ferleri 1, 3, 4, 7 gibi s\u0131raland\u0131\u011f\u0131nda baz\u0131 raporlama ekranlar\u0131nda veya g\u00f6rsel \u00e7\u0131kt\u0131larda d\u00fczensizlik hissi yaratabilir.<\/p>\n\n\n\n<p>E\u011fer tablonuzdaki <code>ID<\/code> s\u00fctunu <code>IDENTITY<\/code> \u00f6zelli\u011fine sahipse, bu alan do\u011frudan g\u00fcncellenemez. Ancak a\u015fa\u011f\u0131daki ad\u0131mlar\u0131 takip ederek bu s\u00fctunu s\u0131f\u0131rdan ba\u015flayacak \u015fekilde yeniden s\u0131ralayabilirsiniz.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\u2705 1. Identity \u00d6zelli\u011fini Ge\u00e7ici Olarak Kapat\u0131n<\/h2>\n\n\n\n<p>SQL Server Management Studio (SSMS) \u00fczerinden ilgili tabloyu a\u00e7\u0131n:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Tablonun \u00fczerine sa\u011f t\u0131klay\u0131n ve <strong>Design (Tasar\u0131m)<\/strong> se\u00e7ene\u011fine t\u0131klay\u0131n.<\/li>\n\n\n\n<li><code>ID<\/code> s\u00fctununu se\u00e7in.<\/li>\n\n\n\n<li>Sa\u011f taraftaki <strong>Column Properties (S\u00fctun \u00d6zellikleri)<\/strong> b\u00f6l\u00fcm\u00fcnden:\n<ul class=\"wp-block-list\">\n<li><strong>Identity Specification<\/strong> \u2192 <strong>(Is Identity)<\/strong> se\u00e7ene\u011fini <strong>No<\/strong> olarak de\u011fi\u015ftirin.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>De\u011fi\u015fikli\u011fi kaydedin (CTRL + S).<\/li>\n<\/ol>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p>Bu ad\u0131m, <code>ID<\/code> s\u00fctununun otomatik artan \u00f6zelli\u011fini devre d\u0131\u015f\u0131 b\u0131rak\u0131r ve elle g\u00fcncellenebilir hale getirir.<\/p>\n<\/blockquote>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\u2705 2. ID De\u011ferlerini Yeniden S\u0131ralay\u0131n<\/h2>\n\n\n\n<p>A\u015fa\u011f\u0131daki SQL sorgusunu \u00e7al\u0131\u015ft\u0131rarak mevcut <code>ID<\/code> de\u011ferlerini s\u0131f\u0131rdan ba\u015flayacak \u015fekilde g\u00fcncelleyebilirsiniz:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\"><code>WITH S\u0131ralama AS (<br>    SELECT ID, ROW_NUMBER() OVER (ORDER BY ID) AS YeniID<br>    FROM Tablo_Adi<br>)<br>UPDATE S\u0131ralama<br>SET ID = YeniID;<br><\/code><\/pre>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p>Not: <code>Tablo_Adi<\/code> ifadesi yerine kendi tablo ad\u0131n\u0131z\u0131 yazmay\u0131 unutmay\u0131n.<\/p>\n<\/blockquote>\n\n\n\n<p>Bu sorgu, kay\u0131tlar\u0131 mevcut <code>ID<\/code> s\u0131ras\u0131na g\u00f6re s\u0131ralar ve her sat\u0131ra 1\u2019den ba\u015flayarak yeni bir s\u0131ra numaras\u0131 atar.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\u2705 3. Identity \u00d6zelli\u011fini Yeniden A\u00e7\u0131n<\/h2>\n\n\n\n<p>\u0130\u015flem tamamland\u0131ktan sonra <code>IDENTITY<\/code> \u00f6zelli\u011fini tekrar aktif hale getirmek i\u00e7in \u015fu ad\u0131mlar\u0131 izleyin:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Tablonun \u00fczerine sa\u011f t\u0131klay\u0131n ve <strong>Design (Tasar\u0131m)<\/strong> se\u00e7ene\u011fini se\u00e7in.<\/li>\n\n\n\n<li><code>ID<\/code> s\u00fctununu tekrar se\u00e7in.<\/li>\n\n\n\n<li>Sa\u011f taraftaki <strong>Column Properties<\/strong> b\u00f6l\u00fcm\u00fcnden:\n<ul class=\"wp-block-list\">\n<li><strong>Identity Specification<\/strong> \u2192 <strong>(Is Identity)<\/strong> se\u00e7ene\u011fini <strong>Yes<\/strong> olarak de\u011fi\u015ftirin.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Gerekirse <strong>Identity Seed<\/strong> ve <strong>Increment<\/strong> de\u011ferlerini 1 olarak ayarlay\u0131n.<\/li>\n\n\n\n<li>De\u011fi\u015fikli\u011fi kaydedin (CTRL + S).<\/li>\n<\/ol>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\ud83c\udfaf Sonu\u00e7<\/h2>\n\n\n\n<p>Bu y\u00f6ntem sayesinde:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><code>ID<\/code> s\u00fctunundaki de\u011ferler s\u0131f\u0131rdan ba\u015flayarak s\u0131ralan\u0131r.<\/li>\n\n\n\n<li><code>IDENTITY<\/code> \u00f6zelli\u011fi korunur ve yeni kay\u0131tlar otomatik olarak artmaya devam eder.<\/li>\n\n\n\n<li>Veriler silinmeden, d\u00fczenli bir <code>ID<\/code> yap\u0131s\u0131na kavu\u015fmu\u015f olursunuz.<\/li>\n<\/ul>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Veritabanlar\u0131nda otomatik artan ID s\u00fctunu, zamanla silinen kay\u0131tlar veya d\u0131\u015far\u0131dan yap\u0131lan veri giri\u015fleri nedeniyle s\u0131ral\u0131 olmayabilir. \u00d6rne\u011fin, ID de\u011ferleri 1, 3, 4, 7 gibi s\u0131raland\u0131\u011f\u0131nda baz\u0131 raporlama ekranlar\u0131nda veya g\u00f6rsel \u00e7\u0131kt\u0131larda d\u00fczensizlik hissi yaratabilir. E\u011fer tablonuzdaki ID s\u00fctunu IDENTITY \u00f6zelli\u011fine sahipse, bu alan do\u011frudan g\u00fcncellenemez. Ancak a\u015fa\u011f\u0131daki ad\u0131mlar\u0131 takip ederek bu s\u00fctunu s\u0131f\u0131rdan ba\u015flayacak \u015fekilde &hellip;<\/p>\n","protected":false},"author":1,"featured_media":419,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[64],"tags":[],"class_list":["post-418","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sql"],"_links":{"self":[{"href":"https:\/\/www.hasanbirden.com\/blog\/wp-json\/wp\/v2\/posts\/418","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.hasanbirden.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.hasanbirden.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.hasanbirden.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.hasanbirden.com\/blog\/wp-json\/wp\/v2\/comments?post=418"}],"version-history":[{"count":2,"href":"https:\/\/www.hasanbirden.com\/blog\/wp-json\/wp\/v2\/posts\/418\/revisions"}],"predecessor-version":[{"id":421,"href":"https:\/\/www.hasanbirden.com\/blog\/wp-json\/wp\/v2\/posts\/418\/revisions\/421"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.hasanbirden.com\/blog\/wp-json\/wp\/v2\/media\/419"}],"wp:attachment":[{"href":"https:\/\/www.hasanbirden.com\/blog\/wp-json\/wp\/v2\/media?parent=418"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.hasanbirden.com\/blog\/wp-json\/wp\/v2\/categories?post=418"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.hasanbirden.com\/blog\/wp-json\/wp\/v2\/tags?post=418"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}