Skip to main content

Jan Driscoll

Member since Dec 11, 2008

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, I'm not ... 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. None of my attemp... read more »

I believe in love. I believe in compassion. I believe in human rights. I believe that we can afford to give more of these gifts to the world around us because it costs us nothing to be decent and kind and understanding. And, I want you to know that when you land on this site, you are accepted for who you are, no matter how you identify, what truths you live, or whatever kind of goofy shit makes you feel alive! Rock on with your bad self!
— Ben Nadel