Post reply

Auto updating when date changes

  • March 26, 2006 at 10:08 pm

    #96922

    Dear All,

    I would like to execute query or update table when date changes. How it can be done in SQL7? Can you able to guide me to do this. Thanks in Advance.

    Regards

    Karthi

  • March 27, 2006 at 5:23 am

    #628854

    You can use trigger to do this.

  • March 28, 2006 at 3:36 am

    #629109

    yes, but how i trigger the trigger?

    The thing is i need to activate trigger when the date change to another date

    for example

    when current date is 01/Jan/2006 when current date is changed to 02/Jan/2006 during the change of time i need to activate trigger. can you guide to solve this problem?

    thanks

    Karthi

  • March 28, 2006 at 5:09 am

    #629117

    You should be able to do this with a sql server job. Just schedule it to run a stored procedure at Midnight to update your table.

  • March 28, 2006 at 9:16 pm

    #629350

    hi grasshopper,

    thanks for your guide, i will try as per you suggestion.

    all the best, be happy

    regards

    karthi

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply