|
Posted by Chris.Cheney on 05/10/07 17:27
"Plamen Ratchev" <Plamen@SQLStudio.com> wrote in news:STG0i.9686$j63.2095
@newsread2.news.pas.earthlink.net:
> Although CURRENT_TIMESTAMP/GETDATE is listed as non-deterministic, it is
> deterministic at the statement level (it is evaluated only once per
> statement).
>
> Try this query on any large table:
>
> SELECT *, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP
> FROM AnyLargeTable
> WHERE CURRENT_TIMESTAMP = CURRENT_TIMESTAMP
> AND CURRENT_TIMESTAMP = CURRENT_TIMESTAMP
>
>
> Plamen Ratchev
> http://www.SQLStudio.com
I hoped that was the case - thanks for confirming it.
Chris
Navigation:
[Reply to this message]
|