Latest members | More ...
I want to convert data from one table to another by using cursor
My case is
I have table App_Profile and have data's in it i want to convert datas corresponding to particular id to another table emp_Profile.There may be more than one rows for each id...whatever be the number i want whole data corresponmding to that id to another table ..
Can anybody suggest idea i want to write code in backend side
Thanks in advance
insert into table2 (Id,Name)
select nID,sName from table1 where nID = 2
Amritha444, if this helps please login to Mark As Answer. |
Reply | Alert Moderator
Write New Post | More ...