Eric Barro
ebarro at verizon.net
Thu Jun 11 19:04:29 CDT 2009
I believe you will have unique datetime values for each record. -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of jwcolby Sent: Thursday, June 11, 2009 4:53 PM To: Dba-Sqlserver Subject: [dba-SQLServer] Update using GetDate() 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 _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com