I want to copy some fileds of a table data to another database table
how?
Here not copy a full of table data...
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Satyapriya NayakPosted Jan 2, 2012, 5:29 AM
select columnname into newtable from oldtable
Ex:
SELECT empname
INTO employee1
FROM employee
Thanks
Sam HobbsPosted Jan 2, 2012, 5:02 AM
Pravin MorePosted Jan 2, 2012, 3:45 AM