In my first post i had wrote that what i used to tranfer data from one table to other. TW i asked him not to ask "why"
When we face a interview we try to give all possible answer to the interviewer which we faced in our previous and present jobs.
But if the interviewer ask the question like this then what u will answer.
There is a table A in DB sales and a table B in DB sales.Table a is being accessed by more then 300 users (24*7) mode.I need to tranfer the data of Table A into Table B without troubling the connected users.
The size of the table is 16 GB.
Table B is null before the datatansfer.
(I used lot of ways to tanfer data and nealy i explained all those ways to the interviewer but he was not satisfied by my answer).
I also explained the one that jeff wrote.
Can u pls shed more light on this.
I already thanked Bkelley for his precious time and help.
The explanation given by bkelly is nice which cleared my confusion.
Thanks once again to Bkelley.