Wednesday 7 September 2011

How to copy only a single and multiples columns to an another table

insert into dupemp(name) select Emp_name from emp  ---- for Single Column

insert into orderbookhistory select * from orderbook where order_no ---for multiple Columns



No comments:

Post a Comment