I am designing a database in which the value of an item should be auto increased after continuous time.
suppose I've an entity; interestRate whose value is initially 15 initially. Now after 10 days it should be 16 and go on increasing by unit value within the interval of 10 days.
@ X002548. Thanks for the reply. ya sometimes it is tedious to manually update the values. in my case, the value of interestRate is increasing periodically not arbitrarily. Its increasing with time, unit increase in 10 days. Can i do it from sql or I've to use servlet programing(i am using C# and asp.net)?