Re: UPDATE on a column with a set default
- From: "David Portas" <REMOVE_BEFORE_REPLYING_dportas@xxxxxxx>
- Date: 30 Jan 2006 13:01:33 -0800
Mike Husler wrote:
> 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
If you actually put UPDATEs in client code then you are certainly
making life difficult for yourself. Had you used a stored procedure for
data access you could just have modified the proc. Any good reason why
you aren't using procs?
Otherwise I think you'll have to use a trigger or put the DEFAULT
keyword in your UPDATE:
UPDATE your_tbl
SET col = DEFAULT ;
--
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--
.
- References:
- UPDATE on a column with a set default
- From: Mike Husler
- UPDATE on a column with a set default
- Prev by Date: Re: T-SQL ROUND(decimal, int) vs C# Round(Decimal, Int32)
- Next by Date: Re: SQL Server does not exist or access denied
- Previous by thread: UPDATE on a column with a set default
- Next by thread: Re: UPDATE on a column with a set default
- Index(es):
Relevant Pages
|
|
