[dba-SQLServer] Update using GetDate()

David McAfee davidmcafee at gmail.com
Thu Jun 11 19:14:54 CDT 2009


They are individual.

On a recent import of 22188 records. I obtained these 11 unique time stamps:

2009-06-11 05:45:04.857
2009-06-11 05:45:04.637
2009-06-11 05:45:03.480
2009-06-11 05:45:03.683
2009-06-11 05:45:04.780
2009-06-11 05:45:04.480
2009-06-11 05:45:03.607
2009-06-11 05:45:04.247
2009-06-11 05:45:03.373
2009-06-11 05:45:04.920
2009-06-11 05:45:04.717


On Thu, Jun 11, 2009 at 4:52 PM, jwcolby <jwcolby at colbyconsulting.com>wrote:

> 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