CodePlexProject Hosting for Open Source Software
I want to copy one table data into another table using
select in insert into
I want to execute query like
"Insert Into TableName Select * from AnotherTable"
Both tables have same structure in database
How can i do this ?
thanks in advance.
DBSelectQuery sel = DBQuery.SelectFields("one", "two", "three")
DBQuery ins = DBQuery.InsertInto("MyTable").Fields("one", "two", "three")
thanks to u.
you really did a nice job.
Are you sure you want to delete this post? You will not be able to recover it later.
Are you sure you want to delete this thread? You will not be able to recover it later.