My tables are sample and delete1
i should delete the rows from sample table and it should be inserted into delete1 table
Plzzzzzzzz help in this.
Thanks a lot.
My tables are sample and delete1
i should delete the rows from sample table and it should be inserted into delete1 table
Plzzzzzzzz help in this.
Thanks a lot.
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Ryan AlfordPosted Oct 18, 2008, 9:55 AM
SELECT * FROM Sample
DELETE FROM Sample