kewlsammie Posted March 30, 2006 Share Posted March 30, 2006 i have 2 tables.... current and previous tables.....i wanna copy all the data in current tables into previous tables...anyone knoe how i can do it wif ASP or SQL?? Any help will be much apperciated~ =) Link to comment Share on other sites More sharing options...
pulpfiction Posted March 30, 2006 Share Posted March 30, 2006 This is the sql query, if you want to do it once then this will work....INSERT INTO TABLE2 SELECT * FROM TABLE1Check out this link too...http://www.databasejournal.com/features/ms...cle.php/3507171 Link to comment Share on other sites More sharing options...
kewlsammie Posted March 31, 2006 Author Share Posted March 31, 2006 hey! thankz! it WORKED!!! AMAZING~! ya been a GREAT help! =) This is the sql query, if you want to do it once then this will work....INSERT INTO TABLE2 SELECT * FROM TABLE1Check out this link too...http://www.databasejournal.com/features/ms...cle.php/3507171<{POST_SNAPBACK}> Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now