Post reply

trigger for time update

  • February 19, 2009 at 7:35 am

    #131082

    I am writing a sql trigger where i need to update the time in every 2 hour in following table

    idScheduleTime

    15:01 AM1

    25:05 AM1

    so after 2 hour it should be

    idScheduleTime

    17:01 AM1

    27:05 AM1

    any ideas?

  • February 19, 2009 at 8:20 am

    #946749

    Why a Trigger and not a job?

    Why even store that value if it can be calculated?

    Can you be more specific on what are you trying to accomplish?


    * Noel

  • February 19, 2009 at 8:22 am

    #946750

    A trigger won't really do that. Triggers are things that happen because of data events, limited to update, insert, delete statements, or DDL events, like creating or dropping objects.

    If you need something to happen at a scheduled interval, you need a job, not a trigger.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

Viewing 3 posts - 1 through 2 (of 2 total)

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