[dba-SQLServer] Update using GetDate()

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




More information about the dba-SQLServer mailing list