Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2011
    Posts
    2

    Unanswered: Updation in table

    Hi,

    Thanks for posting reply Wim.

    My previous post was how can i delete a record
    from one table and insert the same record into another table
    by checking the Status of a drug.
    Apart from writing the insert, delete queries,
    i wanted to have a timer and it should automatically update the
    Status of drugs if the clock hits 12.00AM everyday otherwise at the time when i open my application.
    Is it possible to implement this idea in MS SQL Server.
    Pls do help me in implementing this idea even better.

    Thanks.

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,799
    Provided Answers: 11
    Did you forget your other thread?

  3. #3
    Join Date
    Sep 2010
    Posts
    153

    write a trigger

    ..write a deleted trigger on the table..

    and mention your time in it..

    it will work for you.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •