{"id":436,"date":"2009-02-05T17:56:30","date_gmt":"2009-02-05T16:56:30","guid":{"rendered":"http:\/\/www.galhano.com\/blog\/?p=436"},"modified":"2009-02-05T17:56:34","modified_gmt":"2009-02-05T16:56:34","slug":"sql-server-duplicacao-de-registos-indexados","status":"publish","type":"post","link":"http:\/\/galhano.com\/blog\/?p=436","title":{"rendered":"SQL Server: Duplica\u00c3\u00a7\u00c3\u00a3o de registos indexados"},"content":{"rendered":"

———————————————————————-
\n— Carlos Galhano 2009.02.05
\n— Duplica\u00c3\u00a7\u00c3\u00a3o de Registos indexados
\n–tab teste: testeid,titulo
\n–tab teste2: teste2id,titulo2,testeid
\n———————————————————————-
\nAlter table teste add oldid integer
\n———————————————————————-
\nSelect TesteID, Titulo INTO #tmpteste FROM teste
\ngo
\ninsert into teste (Titulo,oldid) (Select Titulo,testeid from #tmpteste)
\ngo<\/p>\n

—————–
\nSelect teste.TesteID, teste2.Titulo2 INTO #tmpteste2 FROM teste2 inner join teste on teste.oldid=teste2.testeid
\ngo
\n—————–
\ninsert into teste2 (Titulo2,testeID)
\n((Select\u00c2 Titulo2,testeid from #tmpteste2\u00c2 ))
\ngo
\n—————–
\ndrop table #tmpteste
\ngo
\ndrop table #tmpteste2
\ngo
\n—————–
\nAlter table teste drop column oldid
\n———————————————————————-<\/p>\n","protected":false},"excerpt":{"rendered":"

———————————————————————- — Carlos Galhano 2009.02.05 — Duplica\u00c3\u00a7\u00c3\u00a3o de Registos indexados –tab teste: testeid,titulo –tab teste2: teste2id,titulo2,testeid ———————————————————————- Alter table teste add oldid integer ———————————————————————- Select TesteID, Titulo INTO #tmpteste FROM teste go insert into teste (Titulo,oldid) (Select Titulo,testeid from #tmpteste) go —————– Select teste.TesteID, teste2.Titulo2 INTO #tmpteste2 FROM teste2 inner join teste on teste.oldid=teste2.testeid go […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"close","ping_status":"close","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[9],"tags":[79],"class_list":["post-436","post","type-post","status-publish","format-standard","hentry","category-sql-server","tag-sqlserver","author-admin"],"_links":{"self":[{"href":"http:\/\/galhano.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/436","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/galhano.com\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/galhano.com\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/galhano.com\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/galhano.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=436"}],"version-history":[{"count":0,"href":"http:\/\/galhano.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/436\/revisions"}],"wp:attachment":[{"href":"http:\/\/galhano.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=436"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/galhano.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=436"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/galhano.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=436"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}