I have two table suppose TableA and TableB. both tables having their own fields, Now I want to Copy data from one table to another, both tables fields data types are same but name are different and I want to Copy one by one record from TableA to TableB, How can I do That.
Table A TableB
Id Marks Passing date Roll No Marks Resultdate
101 85 5/12/2014 101 85 5/12/2014
102 70 5/25/2014 102 70 5/25/2014
So how can I copy data from Table A if I want same data in TableB