Insert Into Table From Another Table

Posted on By David Kittell

If the two tables structure match you can do this command

INSERT INTO <Destination Table>
SELECT *
FROM <Source Table>
Originally Posted on August 7, 2013
Last Updated on October 26, 2015
All information on this site is shared with the intention to help. Before any source code or program is ran on a production (non-development) system it is suggested you test it and fully understand what it is doing not just what it appears it is doing. I accept no responsibility for any damage you may do with this code.
Access Code MSSQL SQL

Related Posts

Delete Duplicate Rows

Posted on

CREATE TABLE DuplicateRcordTable (Col1 INT, Col2 INT) INSERT INTO DuplicateRcordTable SELECT 1, 1 UNION ALL SELECT 1, 1 –duplicate UNION ALL SELECT 1, 1 –duplicate UNION ALL SELECT 1, 2 UNION ALL SELECT 1, 2 –duplicate UNION ALL SELECT 1, 3 UNION ALL SELECT 1, 4 GO SELECT * FROM…

Read More

Ektron – Widget Form

Posted on

In the recent upgrade from Ektron 8.0.2 to 8.7 I’ve been rebuilding forms to user controls that can be used as widgets. Below is basic elements to make the form work for your Ektron 8.7 (possibly higher). Please note the TextBox SubmissionEmail, this allows you to change the email address…

Read More

Hide/Unhide Element Via ID

Posted on

In this code it is important to have visibility = ‘hidden’ and display = ‘none’ to hide without leaving white space function off(i) { document.getElementById(i).style.visibility = ‘hidden’; document.getElementById(i).style.display = ‘none’; } In this code it is important to have visibility = ” and display = ” to show function on(i)…

Read More