What is the deterministic property?  How does the deterministic property affect computed columns?

Chapter 8: Creating Databases and Tables

What affects the deterministic property?

The deterministic property depends on whether the expression contains any nondeterministic elements, such as various system functions, user-defined functions, and global variables.

Whether a function is deterministic or nondeterministic depends on the function coding:





Copyright © 2005. Sybase Inc. All rights reserved. How does the deterministic property affect computed columns?

View this book as PDF