Viewing 15 posts - 31 through 45 (of 110 total)
SQLRNNR (12/23/2011)
Mike Dougherty-384281 (12/23/2011)
Just to clarify for those confused by the eating association to these animals, we don't eat black cats for Halloween either.
Well, maybe. Ever heard the song...
December 23, 2011 at 9:36 am
.
Although Hugo's post is written with clarity and precision, I had to read it about 6 times before I understood what was going on. Not sure why I'm so...
December 13, 2011 at 9:29 am
.
L' Eomot Inversé (11/23/2011)
November 23, 2011 at 7:45 am
Dwayne Dibley (11/18/2011)
So this shows that the loss of precision is not as well understood as it could be.
I thought I knew the answer. I was wrong. That...
November 22, 2011 at 7:33 am
I've described myself as a programmer for many years. When saying this to new people at parties I find they seem scared they will be button-holed into a tedious...
November 21, 2011 at 12:09 pm
Hugo Kornelis (11/10/2011)
I only got it right because I figured that the relative order of the date and time related values would be "logical". And since the conversion to smalldatetime...
November 10, 2011 at 2:39 pm
philip.cullingworth (11/3/2011)
You can not set the value of a variable at the same time as declaring it until SQL 2008.
Well, color me pleased! Until now, I never realized you...
November 3, 2011 at 7:45 am
mtassin (10/24/2011)
Carla Wilson-484785 (10/24/2011)
Hugo Kornelis (10/24/2011)
UPDATE TOP(1) Table1
SET Column1 = 0
WHERE Column1 = 1;
Since row order...
October 24, 2011 at 2:48 pm
Kenneth J. Moore (10/24/2011)
UPDATE table1
SET ...
October 24, 2011 at 12:07 pm
>>Sometimes a QoTD followed by a great debate is better than reading a big book chapter on the subject.
Well said, codebyo. This question is a great example of such.
October 24, 2011 at 9:59 am
We have a couple SS2005 to accommodate third-party apps that require it. Otherwise, we upgraded everything from SS2000 to SS2008 about two years ago. At that time, we...
October 21, 2011 at 8:40 am
I chose the only two true answers and didn't get credit for a correct answer. Relying on this as my source of information:
October 20, 2011 at 7:50 am
BenWard (10/11/2011)
wware (10/11/2011)
October 11, 2011 at 10:28 am
I honestly never heard of EXCEPT or INTERSECT before either. Seeing them today for the first time, they work exactly as I'd expect them to. I can definitely...
October 11, 2011 at 7:26 am
michael.kaufmann (10/6/2011)
Got it right--for SQL Server 2005 😉Thanks for a straightforward question.
And you might find this link helpful as well.
Regards,
Michael
I recommend Michael's link as well.
In SQL Server 2005 and earlier,...
October 6, 2011 at 11:51 am
Viewing 15 posts - 31 through 45 (of 110 total)