UPDATE on a column with a set default

From: Mike Husler <Michael.P.Husler@xxxxxxxx>
Date: Mon, 30 Jan 2006 12:47:03 -0700

If we have a column with a default value set, say GETDATE( ), how can we assure that value is reset on an UPDATE (not an INSERT) without changing the client code that does the updating? I'd rather stay away from triggers, etc if possible.

Thanks,
Mike Husler
.

Follow-Ups:
- Re: UPDATE on a column with a set default
  - From: me321701
- Re: UPDATE on a column with a set default
  - From: David Portas

Prev by Date: Re: ORDER BY in VIEW not working
Next by Date: Re: T-SQL ROUND(decimal, int) vs C# Round(Decimal, Int32)
Previous by thread: T-SQL ROUND(decimal, int) vs C# Round(Decimal, Int32)
Next by thread: Re: UPDATE on a column with a set default
Index(es):
- Date
- Thread