move a row from one table to another

[Brian Henry]

is there anyway to move a row from one data table to another with the same
schema?

 

[Dino Chiesa [Microsoft]]

yup.

This example COPIES data from one table to another (tables reside in
different DBs)
http://cheeso.members.winisp.net/srcview.aspx?dir=misc&file=CopyData-SqlToDb2.cs

If you want to MOVE, meaning delete the row from the first table, after it
is inserted into the first, that is a simple extension. In that case, you
might want to wrap the whole thing in a transaction.

-D

 

[Jeff Dillon]

What databases?

 

[Brian Henry]

in a dataset

What databases?