Now wants to shear the a record in table 1 to table 2, my approach is to use the insert first insert the record in table 2 of all field values, and then delete this record in table 1, but always feel too much trouble, I don't know which player can pass an SQL statement to achieve! Thanks for comment!

CodePudding user response:

Like there is no such grammar in t-sql

CodePudding user response:

Agree with upstairs, doing the simple things get so complicated, done in the trigger is finished

CodePudding user response:

What triggers it? Later I use data window setitem statement but how also can't update the database, which master can give a best qq online chat, thanks a lot!

CodePudding user response:

Setitem?
That must be set in the dw first allowed to update

CodePudding user response:

As if it's not that simple, ha ha.