Auto Update of the Table in sql Server 2008

[sth_syed]

I want update or change the status of a column in a table after 24 hours entering in the database.

How i can achieve this one with code.

I am using Sql server 2008

Thanks.

[gbritton]

Write a simple SQL Server Agent job to do the update.

[JeffModen]

@sth_syed

I want update or change the status of a column in a table after 24 hours entering in the database.

How i can achieve this one with code.

I am using Sql server 2008

Thanks.

Having such temporal dependencies in tables that require something external to be executed is a REALLY bad idea on several levels. This really should be done in the code that accesses the table.