Your browser does not seem to support JavaScript. As a result, your viewing experience will be diminished, and you have been placed in read-only mode.

Please download a browser that supports JavaScript, or enable it if it's disabled (i.e. NoScript).

How to update records of a table automatically based on date

2 Posts 2 Posters 0 Views 1 Watching

K Offline
K Offline
Krishhhhhhhhhhhhhh

wrote on last edited by

#1

Am using MS sql server 2005 database. Table has 3 columns: 1)Id 2)Status 3)ExpireDate If Expire Date is today then status has to become false otherwise true. It has to done automatically. How to do it? Please help me
B 1 Reply Last reply

0
K Krishhhhhhhhhhhhhh

Am using MS sql server 2005 database. Table has 3 columns: 1)Id 2)Status 3)ExpireDate If Expire Date is today then status has to become false otherwise true. It has to done automatically. How to do it? Please help me
B Offline
B Offline
Bassam Saoud

wrote on last edited by

#2

Create a sql job[^]
1 Reply Last reply

0

Log in to reply