The trigger is not stable, sometimes update fails, PB + SQLSERVER2000,
Pb update table in A published when touch A update trigger, the trigger function is according to A child in A period of value to update the table data from another table b, but sometimes, sometimes can't, not found, but the code of pb in execution time is essentially query analyzer can each time, I didn't commit point inside the trigger, nor rolback transaction statement, because pb automatic management affairs, but why in the query analyzer to perform well?

CodePudding user response:

Estimates that trigger to write a little question,
For example in the primary key aspects,

CodePudding user response:

Possibility:
Trigger problems, for example in the pb may update multiple lines, is in the data window update conditions set has a problem, is not the only, so it needs to do more rows of data in the trigger, it must be processed, or abnormal,


You can set the pb of several Windows update posted, stick the trigger out look,

CodePudding user response:

up

CodePudding user response:

The building Lord hehe check their problem

CodePudding user response:

I also want to know, is looking for this information ~ ~ ~ ~ ~