Viewing 15 posts - 2,881 through 2,895 (of 3,658 total)
I find that datetime comparisons are a mine field because your configuration of SQL can be set to accept M/D/Y or D/M/Y so 02/10/2005 can be 10th February or 2nd...
February 10, 2005 at 1:33 pm
Thanks Frank,
If you notice your site traffic jump through the roof it will be my fault!
Judging by the sheer volume of SPAM I get there isn't a limit to the...
February 10, 2005 at 4:24 am
2Gb of data. War and Peace in PDF form is only around 200Mb.
February 10, 2005 at 2:43 am
I visited northern Massachussets where it takes 15 minutes to walk off your own property and I would guess that identity theft would not be a problem there.
I live in...
February 10, 2005 at 2:42 am
If you are just interested in people of 17 or over then add WHERE age>=17 to your SQL, then a simple COUNT(*) will be the sum.
February 10, 2005 at 2:34 am
The looping around the a select statement works quite well because the locks are only held for a short period of time.
February 9, 2005 at 8:45 am
We have a recycling scheme in my local area so all junk mail goes straight in the recycling bag.
It is the plastic tat from McDonalds happy meals that bugs me!
In...
February 9, 2005 at 8:34 am
If you use a user defined function in this way then I believe that SQL will use an implicit cursor because the function has to work on a row by...
February 9, 2005 at 2:53 am
Try http://spambayes.sourceforge.net/windows.html
You have to install Python on your PC but it is easy enough to install.
Make a folder in outlook and store all your spam in it until you have...
February 9, 2005 at 2:02 am
You can happily fire off stored procedures from within stored procedures.
Let us suppose you have a return value. You could include syntax as follows
DECLARE @lResult Int
exec @lResult=usp_myproc
If you...
February 9, 2005 at 1:56 am
Pretty unanimous opinion here Steve. I'm afraid you are just going to have to keep writing those editorials!
February 8, 2005 at 1:39 am
Using the Outlook 2003 blocked senders facility I blocked 113 SPAMS this morning.
Every morning I add between 20 and 30 new addresses to the list.
Theoretically I should trawl through the...
February 8, 2005 at 1:35 am
And of course having a son who can jump start a car without tools is always a blessing!
I wonder if they are still looking for extras in the next X-men...
February 7, 2005 at 9:21 am
During the first year your hi-fi and personal possessions are safe.
You put the baby down it stays put.
After that they follow you EVERYWHERE and get into EVERYTHING.
Blackcurrant juice...
February 7, 2005 at 4:05 am
There are two ways to do this.
1. Use either a TEXT or NTEXT field.
2. Compress your string in some way
Personally, I would go with option 1.
Option 2 is messy and...
February 7, 2005 at 1:28 am
Viewing 15 posts - 2,881 through 2,895 (of 3,658 total)