B Brian Henry Nov 19, 2004 #1 is there anyway to move a row from one data table to another with the same schema?
D Dino Chiesa [Microsoft] Nov 19, 2004 #2 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
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
