Copying a Row?
Posted on 2008-10-31
I have an Orders Table and I would like to copy an Order and assign it to another Order.
The only thing that would be required to changed would be the field CustomerID where I would change the customerID for that order.
The obvious approach would be to copy out all the fields from the order and insert it into the new row. But is there anyway automate this so it automatically does the insert and update for me?