Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««1234

TSQL Expand / Collapse
Author
Message
Posted Tuesday, April 21, 2009 1:31 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, March 17, 2014 7:18 AM
Points: 2,439, Visits: 6,426
The QoTD did not mention which version of SQL it was referring to. That's why further up I said that the link given in the explanation mentions SQL2000, and that under SQL2K8 (and SQL2K5, which I subsequently confirmed) the only functions out of that list that cannot be used are RAND() and NEWID().

Hope this clears things up
Jan


--------------------------------------------------------------------------
A little knowledge is a dangerous thing (Alexander Pope)

In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)
Post #701206
Posted Wednesday, April 22, 2009 8:23 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Tuesday, July 15, 2014 9:54 AM
Points: 448, Visits: 356
The answer is clearly both Yes and No. From BOL (2005)
All mathematical functions, except for RAND, are deterministic functions. This means they return the same results each time they are called with a specific set of input values. RAND is deterministic only when a seed parameter is specified. For more information about function determinism

So clearly the answer is YES IF you provide a seed value.

However another BOL (2005) reference states
The following built-in functions from other categories are always nondeterministic

and then includes RAND in the list.
Post #702385
« Prev Topic | Next Topic »

Add to briefcase «««1234

Permissions Expand / Collapse