[thelist] New annoying feature of SQL Server

Lucy Hawker lucy.hawker at easynet.co.uk
Fri Jan 3 11:05:02 CST 2003


Hi,

Not sure if this helps, but when I need to put a current Date and Time into
a table I set the Default value of the datetime column to (getDate()).  Then
don't bother putting the datetime in the query and it will default to the
current system time when a record is created.

Lucy







More information about the thelist mailing list