BULK INSERT STATEMENT

Often we use import & export wizard or some third party toll to insert the data from one tbale to another table in sql.
here i'm givin a simple example:-

insert into TABLE_A SELECT * FROM TABLE_B



how somple..........