{"id":131,"date":"2008-07-14T11:41:01","date_gmt":"2008-07-14T11:41:01","guid":{"rendered":"https:\/\/www.wapshere.com\/missmiis\/?page_id=131"},"modified":"2008-07-14T18:31:49","modified_gmt":"2008-07-14T18:31:49","slug":"sql-query-archive-current-table-to-previous","status":"publish","type":"page","link":"https:\/\/www.wapshere.com\/missmiis\/sql-query-archive-current-table-to-previous","title":{"rendered":"SQL Query: Archive Current table to Previous"},"content":{"rendered":"<p>See post <a href=\"https:\/\/www.wapshere.com\/missmiis\/?p=129\">SQL 2005 MA: Export and Delta Import<\/a>.<\/p>\n<pre>truncate table dbo.MyTable_Previous<\/pre>\n<pre>insert into dbo.MyTable_Previous\r\nselect * from dbo.MyTable<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>See post SQL 2005 MA: Export and Delta Import. truncate table dbo.MyTable_Previous insert into dbo.MyTable_Previous select * from dbo.MyTable<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"jetpack_post_was_ever_published":false,"footnotes":""},"class_list":["post-131","page","type-page","status-publish","hentry"],"jetpack_shortlink":"https:\/\/wp.me\/Pkp1o-27","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.wapshere.com\/missmiis\/wp-json\/wp\/v2\/pages\/131","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.wapshere.com\/missmiis\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.wapshere.com\/missmiis\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.wapshere.com\/missmiis\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.wapshere.com\/missmiis\/wp-json\/wp\/v2\/comments?post=131"}],"version-history":[{"count":0,"href":"https:\/\/www.wapshere.com\/missmiis\/wp-json\/wp\/v2\/pages\/131\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.wapshere.com\/missmiis\/wp-json\/wp\/v2\/media?parent=131"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}