|
Posted by Razvan Socol on 06/26/06 13:30
Zvonko wrote:
> I have a interesting problem. I need to write a trigger that wil go off
> after every sixth row is inserted/updated.
Why would you want to do that ?
> Trigger should get SUM(optzalpak) WHERE sifrob = '30300991' and update the
> column optzalpakuk where sifrob = '30300991' with that value.
You mean "SUM(optzalpak) FROM inserted" or "SUM(optzalpak) FROM PODACI"
?
In other words, you want the sum of the values inserted in that
statement or the sum of all values from the table (for the affected
"sifrob") ?
Razvan
Navigation:
[Reply to this message]
|