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 > >