[dba-SQLServer] Update using GetDate()

jwcolby jwcolby at colbyconsulting.com
Thu Jun 11 18:52:51 CDT 2009


If I update a field in millions of records with GetDate, will every record get the same date / time 
value?  Or will later updates get a later time if the time of that record update happens a second or 
more later than earlier updates?


IOW does SQL Server get one date/time value and use that value for all updates in that query?

-- 
John W. Colby
www.ColbyConsulting.com



More information about the dba-SQLServer mailing list