Pb+ms sql+ triggers must be noted

Pb+ms sql+ triggers must be noted:

if the trigger exists more than two return values, such as two article Update statement that was misjudged as the data is changed and the disk is unsuccessful.

Tips:

Row changed between retrieve and update.

No changes made to database.

so MS SQL triggers must be handled uniformly as:

Trigger start Plus:

[email protected] @ROWCOUNT =0 Return-- Improve Performance

Setnocount on-- do not return the number of statistics, can reduce the frequency of network response, improve performance; Avoid miscalculation as data changes ( Sybase no such problems exist)

...

...

End Plus:

Setnocount off

Pb+ms sql+ triggers must be noted