Results 1 to 3 of 3

Thread: auto delete row under day condition

  1. 02-25-2009, 08:06 PM #1
    sql
    sql is offline Registered User
    Join Date
    Jul 2003
    Posts
    421

    auto delete row under day condition

    my table have on column call submit time 02/22/2009, and I have one column call receiveall, defaul value is false, can I do if 8 days late, the receiveall still false, automatic deal this row???
    ________
    TOYOTA HIACE
    Last edited by sql; 03-06-2011 at 02:08 AM.
    Reply With Quote Reply With Quote
  2. 02-26-2009, 08:45 AM #2
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    Write your code and run it as scheduled job.
    Reply With Quote Reply With Quote
  3. 03-18-2009, 07:22 AM #3
    MAK's Avatar
    MAK
    MAK is offline Registered User
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    or create a trigger that deletes the data whenever a change happens on that table.
    My Site:http://www.mssqlengineering.com
    My Book:http://www.wiley.com/WileyCDA/WileyT...470477288.html
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules