How to Update automatically in Data in Sql Server

Question

I'm using Asp.Net with vb with Sql Server 2005 as Database....

in my Database Table, i'm having Emp_Time_Details Table with ID, Name, Given_Time, Status as columns...

like

ID-----Name-----Given_Time----------------Status

1------as ----2008-10-17 16:23:15.000-------1

2------qw ----2008-10-10 17:5:15.000--------1

3------cv ----2008-10-15 11:3:15.000--------1

4------cd ----2008-10-13 05:45:15.000-------1

5------uj ----2008-10-14 03:2:15.000--------1

By default Status Column will be '1'

Here I want to CHANGE THE STATUS COLUMN AUTOMATICALLY wrt GetDate() in Sql Server 2005..

Like if Given_Time >= GetDate()... I want to change Data inside STATUS COLUMN as '0'

How to Update the Data inside Table AUTOMATICALLY wrt GetDate() in SqlServer-2005.. ie here Data inside column should Keep On checking the GetDate() value for Each & Every Second...

Thank You..

Sukesh Marla · Answer

Use Computed column on Emp_Time_Details Create Table Emp_Time_Details ( ID int Name varchar(max) Given_Time datetime Status as (case when Given_time>getDAte() then 1 else 0 end) ) Check this is correct answer if it helped

Shivanand Arur · Answer

Try using a Trigger.... Just get the given_time in a parameter and once a value is passed just check it with the GetDate() value and trigger an Update Query if the passed value is greater....