July 12, 2012 at 10:32 pm
Can any one describe that what exactly is a Deterministic & non-deterministic result?
July 12, 2012 at 11:12 pm
ankit.singh484 (7/12/2012)
Can any one describe that what exactly is a Deterministic & non-deterministic result?
Hi Ankit,
Have a look on below link.
http://msdn.microsoft.com/en-us/library/ms178091.aspx
--rhythmk
------------------------------------------------------------------
To post your question use below link
https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help
🙂
July 13, 2012 at 3:18 am
Deterministic results will get the same result set at any time with specific set of input values
Ex: dateadd function
Nondeterministic result will get the different result with specific set of input.
Ex : getdate()
July 14, 2012 at 1:36 pm
thanx 🙂
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply