Forum Discussion
Mohammad Ahammad
Jan 05, 2020Copper Contributor
update column after certain time
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 m...
耕志 馮
Jan 29, 2020Brass Contributor
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