Hi
I am having a table with the name A with the one column set to Identity.
I need to copy the records from the table A to B so that i have the same records with the same identity.
i.e in table A i am having no records with the ID 3, 4. But when i copied from the table A to B, the B has records with the ID 3, 4.
So finally i need to copy the same records from the table A to B and i need to set the Identity to B