One other thing if I want this trigger to fire and only do an update when the user is not BLA can i just change the statement to read
set ANSI_NULLS ON
set QUOTED_IDENTIFI ER OFF
GO
ALTER trigger [dbo].[TS_ORDER_UPD]
on [dbo].[TS_ORDER]
for update
as
declare @lastuu varchar(6)
declare @orderid decimal(10)
select @lastuu = [last_upd_user] FROM INSERTED
select @orderid...
arracathce
Last Activity: Sep 5 '07, 02:25 PM
Joined: Aug 30 '07
Location:
-
Can you maybe give me a example since getdate() is always sysdate so I ma confused that this will always continues...Leave a comment:
-
Trigger
I have a table which takes order called ORDER
I need to create a update trigger which fires when a user X makes a transaction else ignore and continue and sleep for n seconds
for update
as
declare @lastuu varchar(6)
declare @orderid decimal(10)
select @lastuu = [last_upd_user] FROM INSERTED
select @orderid = [order_id] FROM INSERTED
if @lastuu='TM_DEV ' -- check user value on...
No activity results to display
Leave a comment: