Community Member Profile
Recent Blog Comments By Jan Driscoll
Posted on Oct 3, 2007 at 10:12 PM
Yup, it was the schema binding! I added WITH SCHEMABINDING and it made all my functions deterministic. In SQL 2005, using floats makes the function non-precise. That is to say, the IsPrecise property will be 0. However, a function can be non-precise but still be deterministic! However,... read more »
Posted on Sep 25, 2007 at 6:18 PM
Hi, this question is for Joseph Gagliardo. I am trying to write a deterministic function in sql server 2005. I intend to use it in a persisted computed column. The functions I am working on convert RGB color values to HSV and to Hex. However, this is sort of beside the point.
read more »