Solved

"Deterministic and Nondeterministic Functions" it is important?

Posted on 2011-03-01
3
413 Views
Last Modified: 2012-05-11
I am a developer of database objects, that serves me know
"Deterministic and Nondeterministic Functions"
0
Comment
Question by:enrique_aeo
  • 2
3 Comments
 
LVL 39

Accepted Solution

by:
BrandonGalderisi earned 250 total points
ID: 35010494
A deterministic function will always give the same output for the same input.  
A non-deterministic will not always.
0
 

Author Comment

by:enrique_aeo
ID: 35010804
I understand, but that helps me to know that when I'm programming.
0
 

Author Comment

by:enrique_aeo
ID: 35027226
I understand that I do not know this for indexes on computed columns, but there are some more reasons?
0

Featured Post

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Join & Write a Comment

SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now