You are a database developer. You plan to design solutions by using SQL Server 2008 in an enterprise environment.
The database will contain a view. The view will contain a computed column that will be indexed. The computed column will use a user-defined scalar function. The function will perform complex mathematical manipulations using random generated float numeric values.
You need to identify the appropriate function to use to generate random values.
Which function should you use?
A. a deterministic common language runtime (CLR) scalar-valued function
B. a deterministic Transact-SQL table-valued function
C. a nondeterministic Transact-SQL table-valued function to generate random values
D. a nondeterministic common language runtime (CLR) scalar-valued function
