Viewing 6 posts - 16 through 21 (of 21 total)
My preferred alternative (and a variation on choice 4) is to do:
WHERE CAST(CONVERT(char(8), DateVal, 112) AS datetime) = '2003-08-01'
Mainly because I prefer the intermediate character format to casting to a...
August 1, 2003 at 3:59 am
#468156
quote: I read somewhere that although you can specify 8, 16 and 32 bit integers windows converts these all into 32 bit integers...
quote:
July 10, 2003 at 4:35 am
#464781
So, the QOD was a test to understand if we knew the workaround for a bug that has been fixed since MDAC 2.1? Hmmm....
--
Si Chan
Database Administrator
July 1, 2003 at 3:21 am
#463734
quote: quote: In my book, indexes are for data integrity or performance. June 25, 2003 at 7:24 am #463008
quote: In my book, indexes are for data integrity or performance.
June 25, 2003 at 7:24 am #463008
June 25, 2003 at 7:24 am
#463008
quote: So, why use an index anyway, that's what I was originally asking.
In my book,...
June 25, 2003 at 7:01 am
#463001
quote: that's what the tables are. 2, maybe 3 columns. the data inserted hardly never changes. From year to year I guess.
the data inserted hardly never changes. From year to year I guess.
June 25, 2003 at 5:58 am
#462987