Trigger

[arracathce]

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 for Transaction
begin
Update TS_ORDER
set last_upd_date=getdate()
where order_id=@orderid
end

How do I create a timer?
develop a timer on this and/or a method of updating only when the time is every n seconds

[ck9663]

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 for Transaction
begin
Update TS_ORDER
set last_upd_date=getdate()
where order_id=@orderid
end

How do I create a timer?
develop a timer on this and/or a method of updating only when the time is every n seconds

do a loop until you reach the amount of times you want to sleep

curdate = getdate()

while dateadd(ss,10,curdate) <= getdate()
continue


be careful and avoid endless loop


or try waitfor delay

[arracathce]

do a loop until you reach the amount of times you want to sleep

curdate = getdate()

while dateadd(ss,10,curdate) <= getdate()
continue


be careful and avoid endless loop


or try waitfor delay

Can you maybe give me a example since getdate() is always sysdate so I ma confused that this will always continues

[ck9663]

Can you maybe give me a example since getdate() is always sysdate so I ma confused that this will always continues

sorry about that...that's just an algorithm...here's a 3-second timer...

select 'start:' + cast(getdate() as varchar(15))
 
BEGIN
    WAITFOR DELAY '00:00:3'
    select 'end:' + cast(getdate() as varchar(15))
END
GO
 

[arracathce]

sorry about that...that's just an algorithm...here's a 3-second timer...

select 'start:' + cast(getdate() as varchar(15))
 
BEGIN
    WAITFOR DELAY '00:00:3'
    select 'end:' + cast(getdate() as varchar(15))
END
GO
 

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_IDENTIFIER 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 = [order_id] FROM INSERTED
if @lastuu !='BLA' -- SO only execute update and change time when user is not BLA
begin
Update TS_ORDER
set last_upd_date=getdate()
where order_id=@orderid
end

[ck9663]

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_IDENTIFIER 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 = [order_id] FROM INSERTED
if @lastuu !='BLA' -- SO only execute update and change time when user is not BLA
begin
Update TS_ORDER
set last_upd_date=getdate()
where order_id=@orderid
end

if you're storing the username on that field, yes. or you may also check the value of SYSTEM_USER system variable. it returns the current username used to connect to the sql server