Forum Discussion

Copper Contributor

Jan 05, 2020

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...

耕志馮

Brass Contributor

Jan 29, 2020

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