You are a database developer. You plan to design a database solution by using SQL Server 2008. The database will contain a common language runtime (CLR) user-defined scalar function. The function will return an integer value.
You need to ensure that the computed columns that use the result from this function can be indexed.
What should you do?
A. 1. Ensure that the logic of the function returns the same value for the same input values and the same database state.
2. Ensure that the IsDeterministic property is set to True.
B. 1. Ensure that the logic of the function returns a different value for the same input values and the same database state.
2. Ensure that the IsDeterministic property is set to True.
C. 1. Ensure that the logic of the function returns the same value for the same input values and the same database state.
2. Ensure that the IsDeterministic property is set to False.
D. 1. Ensure that the logic of the function returns a different value for the same input values and the same database state.
2. Ensure that the IsDeterministic property is set to False.
