--drop table test --create table test (id int identity, date Datetime default getdate()) --insert test values (default) update test set date=default where id=1 select * from testif you are passing the sql statement to the back end. I don't know how to make ADO.NET generate this command. Does anybody know?