I have Table A and Table B which are similar. Table A is the main table and makes a copy to Table B. Some records in Table A are either added or deleted. Table B is later refreshed with the records in Table A to match it. How can I pragmatically know which were the records that were deleted and added off of table A before refreshing Table B.

uhm... why are you making an exact copy of table A anyway? do you mean you are creating an audit table and table B is updated with "delete" data?

in which case google or search these forums for "audit" or "audit trail" and you'll find heaps of examples and suggestions and code.

otherwise, i'm not sure what you mean to do.