The Point table to replace all the content for the bonus field in the '99999'

The UPDATE Point SET bonus='9999'
The above is my writing is what is wrong, prompt content as follows:

[21000] [Microsoft] [11.0] SQL Server Native Client/SQL Server subquery return values of more than one, when the query to follow in=,!=, & lt; , & lt;=, & gt; , & gt;=, or the subquery is used as the expression, the situation is not allowed, (512)
[01000] [Microsoft] [11.0] SQL Server Native Client/SQL Server statement has been terminated, (3621)

What should I write,

CodePudding user response:

Are there any trigger in point above the table,

CodePudding user response:

reference 1st floor RINK_1 response:

point above the table have a trigger,

There are
I want to how to solve, and I can't move him, this trigger the original content,

CodePudding user response:

refer to the second floor qq_21829433 response:

Quote: refer to 1st floor RINK_1 response:

Point above the table have a trigger,

There are
I want to how to solve, and I can't move him, this trigger the original content,

That when you update this table, a data can be updated at a time, for example, you pass a cursor, or WILE circulation, to update the data, a detailed

CodePudding user response:

reference RINK_1 reply: 3/f

Quote: refer to the second floor qq_21829433 response:

Quote: refer to 1st floor RINK_1 response:

Point above the table have a trigger,

There are
I want to how to solve, and I can't move him, this trigger the original content,

That when you update this table, a data can be updated at a time, for example, you pass a cursor, or WILE circulation, to update the data, a detailed

It seems that only this

CodePudding user response:

, if permissions permission to drop the trigger, the execution of the UPDATE, and then rebuild the trigger.

CodePudding user response:

reference 5 floor Seagull16 reply:

if access permission, can also drop the trigger first, after the UPDATE, and then rebuild the trigger.

Both Please speak in English.