{"id":166,"date":"2012-09-21T08:59:00","date_gmt":"2012-09-21T07:59:00","guid":{"rendered":"https:\/\/blogfvinhas.wordpress.com\/?p=166"},"modified":"2012-09-21T08:59:00","modified_gmt":"2012-09-21T07:59:00","slug":"efetuar-reset-autonumber-identity-column-in-sql-server","status":"publish","type":"post","link":"https:\/\/blog.fvinhas.com\/index.php\/2012\/09\/21\/efetuar-reset-autonumber-identity-column-in-sql-server\/","title":{"rendered":"Efetuar Reset Autonumber (Identity) Column in SQL Server"},"content":{"rendered":"\n<p>Quando se estrutura uma base de dados SQL e queremos ver se tudo est\u00e1 ok, temos que introduzir dados de teste, no entanto no final temos a necessidade de os eliminar, mas quando os eliminamos os contadores n\u00e3o v\u00e3o come\u00e7ar do zero, mas sim a partir do ultimo numero residente em mem\u00f3ria.<\/p>\n\n\n\n<p>Para isso devemos seguir os seguintes passos:<\/p>\n\n\n\n<p>1\u00ba Abrir a base de dados que pretendemos fazer a altera\u00e7\u00e3o<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"552\" height=\"290\" src=\"https:\/\/blog.fvinhas.com\/wp-content\/uploads\/2024\/12\/image-28.png?w=552\" alt=\"\" class=\"wp-image-167\" srcset=\"https:\/\/blog.fvinhas.com\/wp-content\/uploads\/2024\/12\/image-28.png 552w, https:\/\/blog.fvinhas.com\/wp-content\/uploads\/2024\/12\/image-28-300x158.png 300w\" sizes=\"auto, (max-width: 552px) 100vw, 552px\" \/><\/figure>\n\n\n\n<p>2\u00ba Abrir uma query nova<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"336\" height=\"145\" src=\"https:\/\/blog.fvinhas.com\/wp-content\/uploads\/2024\/12\/image-29.png?w=336\" alt=\"\" class=\"wp-image-168\" srcset=\"https:\/\/blog.fvinhas.com\/wp-content\/uploads\/2024\/12\/image-29.png 336w, https:\/\/blog.fvinhas.com\/wp-content\/uploads\/2024\/12\/image-29-300x129.png 300w\" sizes=\"auto, (max-width: 336px) 100vw, 336px\" \/><\/figure>\n\n\n\n<p>3\u00ba Editar a query com as seguintes instru\u00e7\u00f5es<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"586\" height=\"200\" src=\"https:\/\/blog.fvinhas.com\/wp-content\/uploads\/2024\/12\/image-30.png?w=586\" alt=\"\" class=\"wp-image-169\" srcset=\"https:\/\/blog.fvinhas.com\/wp-content\/uploads\/2024\/12\/image-30.png 586w, https:\/\/blog.fvinhas.com\/wp-content\/uploads\/2024\/12\/image-30-300x102.png 300w\" sizes=\"auto, (max-width: 586px) 100vw, 586px\" \/><\/figure>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p>DELETE FROM nometabela<\/p>\n\n\n\n<p>DBCC CHECKIDENT (nometabela,RESEED, 0)<\/p>\n<\/blockquote>\n\n\n\n<p>Neste momento dever\u00e1 aparecer uma mensagem em como as altera\u00e7\u00f5es foram efetuadas com sucesso e o numero de linhas que foram afetadas.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"737\" height=\"146\" src=\"https:\/\/blog.fvinhas.com\/wp-content\/uploads\/2024\/12\/image-33.png?w=737\" alt=\"\" class=\"wp-image-173\" srcset=\"https:\/\/blog.fvinhas.com\/wp-content\/uploads\/2024\/12\/image-33.png 737w, https:\/\/blog.fvinhas.com\/wp-content\/uploads\/2024\/12\/image-33-300x59.png 300w\" sizes=\"auto, (max-width: 737px) 100vw, 737px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"237\" height=\"76\" src=\"https:\/\/blog.fvinhas.com\/wp-content\/uploads\/2024\/12\/image-32.png?w=237\" alt=\"\" class=\"wp-image-172\" \/><\/figure>\n\n\n\n<p>NOTA: As linhas fazem seguintes opera\u00e7\u00f5es:<\/p>\n\n\n\n<p>1\u00aa Linha Apaga os dados contidos na Base de dados<\/p>\n\n\n\n<p>2\u00aa Faz um reset ao contador e inicia-o neste caso por 0, mas poderia ser a partir do 25 por ex.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Quando se estrutura uma base de dados SQL e queremos ver se tudo est\u00e1 ok, temos que introduzir dados de teste, no entanto no final temos a necessidade de os eliminar, mas quando os eliminamos os contadores n\u00e3o v\u00e3o come\u00e7ar do zero, mas sim a partir do ultimo numero residente em mem\u00f3ria. Para isso devemos &#8230; <a title=\"Efetuar Reset Autonumber (Identity) Column in SQL Server\" class=\"read-more\" href=\"https:\/\/blog.fvinhas.com\/index.php\/2012\/09\/21\/efetuar-reset-autonumber-identity-column-in-sql-server\/\" aria-label=\"Read more about Efetuar Reset Autonumber (Identity) Column in SQL Server\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[75,76,86],"class_list":["post-166","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-reseed","tag-reset","tag-sql"],"_links":{"self":[{"href":"https:\/\/blog.fvinhas.com\/index.php\/wp-json\/wp\/v2\/posts\/166","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.fvinhas.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.fvinhas.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.fvinhas.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.fvinhas.com\/index.php\/wp-json\/wp\/v2\/comments?post=166"}],"version-history":[{"count":0,"href":"https:\/\/blog.fvinhas.com\/index.php\/wp-json\/wp\/v2\/posts\/166\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.fvinhas.com\/index.php\/wp-json\/wp\/v2\/media?parent=166"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.fvinhas.com\/index.php\/wp-json\/wp\/v2\/categories?post=166"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.fvinhas.com\/index.php\/wp-json\/wp\/v2\/tags?post=166"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}