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
quote:
I read somewhere that although you can specify 8, 16 and 32 bit integers windows converts these all into 32 bit integers...
July 10, 2003 at 4:35 am
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
quote:
quote:
In my book, indexes are for data integrity or performance.
June 25, 2003 at 7:24 am
quote:
So, why use an index anyway, that's what I was originally asking.
In my book,...
June 25, 2003 at 7:01 am
quote:
that's what the tables are. 2, maybe 3 columns.the data inserted hardly never changes. From year to year I guess.
June 25, 2003 at 5:58 am
Viewing 6 posts - 16 through 21 (of 21 total)