Community Member Profile
Jan Driscoll
Member since Dec 11, 2008
- Profile: /members/2279-Jan-Driscoll.htm
- Comments: 2
- Points: 1
Recent Blog Comments By Jan Driscoll
-
Getting Only the Date Part of a Date/Time Stamp in SQL Server
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 »
-
Getting Only the Date Part of a Date/Time Stamp in SQL Server
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.
