Will GETUTCDATE() return the same value if used twice in the same statement?

by

Thanks to the links provided by gbn, I believe this answers my question:

In common with rand() It is evaluated once per column but once evaluated remains the same for all rows.
…
look at the ComputeScalar operator properties in the actual execution plan you will see that GetDate() is evaluated twice.

I checked, and it appears that this still happens the same way in SQL Server 2008: GetUtcDate() is evaluated twice in the execution plan. It is not going to produce different results per row, but it is possible that it could produce a different result per column if the timing ended up just right.

Edit

I can actually prove this behavior! Try this:

select GETUTCDATE(), RAND(), RAND(), ...[~3000 RAND()s]..., RAND(), GETUTCDATE()
from [TableOfYourChoice]

In my experiment, I ended up with 2011-05-17 20:47:34.247 in the first column and 2011-05-17 20:47:34.250 in the final column, showing a difference of three milliseconds as a result of the evaluation of all the RAND()s between the first and second calls to GETUTCDATE().

More Related Contents:

  1. incorrect syntax near keyword where [closed]
  2. nvarchar concatenation / index / nvarchar(max) inexplicable behavior
  3. How do I create a unique constraint that also allows nulls?
  4. How do I get list of all tables in a database using TSQL?
  5. How to convert SQL Server’s timestamp column to datetime format
  6. Escape a string in SQL Server so that it is safe to use in LIKE expression
  7. Storing files in SQL Server
  8. SQL Server: Difference between PARTITION BY and GROUP BY
  9. Dapper.NET and stored proc with multiple result sets
  10. Import ‘xml’ into Sql Server
  11. Query times out when executed from web, but super-fast when executed from SSMS
  12. T-SQL Dynamic SQL and Temp Tables
  13. Efficient ISNUMERIC() replacements on SQL Server?
  14. Login to Microsoft SQL Server Error: 18456
  15. Adding a query hint when calling Table-Valued Function
  16. Find non-ASCII characters in varchar columns using SQL Server
  17. Violation of UNIQUE KEY constraint on INSERT WHERE COUNT(*) = 0 on SQL Server 2005
  18. How can I determine in SQL Server if a dateTime range overlaps another
  19. Intermittent ODBC connection failures
  20. SQL Server Query – groupwise multiplication
  21. How to create a yes/no boolean field in SQL server?
  22. How do I select last 5 rows in a table without sorting?
  23. displaying multiple records by using resultset
  24. How to display two digits after decimal point in SQL Server
  25. Copy table to a different database on a different SQL Server
  26. Include missing months in Group By query
  27. Generate table relationship diagram from existing schema (SQL Server) [closed]
  28. Bootstrapping SQL Express from WiX?
  29. Error converting data types when importing from Excel to SQL Server 2008
  30. CHECKSUM and CHECKSUM_AGG: What’s the algorithm?

Leave a Comment