Update Trigger in SQL 2000

The Mighty Dubs

Hi, im having problems compiling a trigger. bacically i need the trigger to pull back a number that increments with each update. This is my poor attempt. Any suggestions are more than welcome.


CREATE TRIGGER [UpdCloneItemCode] ON [dbo].[tblUnitMatrix]
FOR UPDATE
AS
Declare @itemcode VARCHAR(50)
If NOT UPDATE(ItemCode)
Begin
Return
END
Select CounterValue From tblCounter
UPDATE tblCounter SET CounterValue=CounterValue+1

Delirium

The Mighty Dubs wrote: »

Hi, im having problems compiling a trigger. bacically i need the trigger to pull back a number that increments with each update. This is my poor attempt. Any suggestions are more than welcome.


CREATE TRIGGER [UpdCloneItemCode] ON [dbo].[tblUnitMatrix]
FOR UPDATE
AS
Declare @itemcode VARCHAR(50)
If NOT UPDATE(ItemCode)
Begin
Return
END
Select CounterValue From tblCounter
UPDATE tblCounter SET CounterValue=CounterValue+1

Do you mean you want to use the variable outside the trigger?

The Mighty Dubs

Correct.Thats the variable i want to insert.

Delirium

The Mighty Dubs wrote: »

Correct.Thats the variable i want to insert.

Ok. You could just query the table that has the value after the insert.

I'm not aware of a way to pass a variable out of a trigger. I've only a limited experience of SQL.