Jan 05 2020 12:27 AM - edited Jan 05 2020 12:28 AM
Greeting everyone
i'm new here and i'm looking for answer for my question
my idea is change value of row after certain time only once
i have column in my table content number which considered as minutes
if there's number on that column mean this row will be update after minutes on that column
and if there's no number on that column there's will be no change
the update will be only once on that row which content number (minutes)
how can i do that?
i'm using that for my c# project
Jan 29 2020 07:18 PM
Hi @Mohammad Ahammad ,
I think the SQL script below may be fit your expectation.
IF exists ( select r_number from orders where r_number is not null and processed_flag = 'N')
Update orders set col1 = xxx
Where r_number is not null
And processed_flag = 'N'
You may change the if clause with C# syntax instead if you want. Hope it is useful for you.
Regards,
Sten