Viewing 15 posts - 3,721 through 3,735 (of 7,484 total)
mike brockington (2/21/2013)
February 21, 2013 at 2:43 pm
JAZZ Master (2/21/2013)
Daniel Bowlin (2/21/2013)
uncertaintyThin ice.
Ice should come in nice bulky cubes. Thin ice would pollute the g&t instead of enhancing it.
February 21, 2013 at 2:33 pm
Right now, I'm feeling embarrassingly stupid. :blush:
I was trying to put together a submission for QotD. But I thought I'd seen too many comments recently where people had...
February 21, 2013 at 2:28 pm
Good question.
I'm glad that missing out WITH is deprecated though, so that teh answer to this question will change in the future. In fact I think it's a great...
February 21, 2013 at 6:40 am
Close to 39k? No, there's still 100+(39*24) to go. 😀
February 20, 2013 at 4:05 pm
wolfkillj (2/20/2013)
venkat9.sql (2/20/2013)
wolfkillj (2/20/2013)
L' Eomot Inversé (2/20/2013)
I really must upgrade and get SQL2012 so that I can start playing with this stuff instead of just reading about it.
If...
February 20, 2013 at 2:54 pm
Nice interesting question.
I really must upgrade and get SQL2012 so that I can start playing with this stuff instead of just reading about it.
If people have run the code and...
February 20, 2013 at 5:29 am
manik123 (2/19/2013)
nice question.... query will execute successfully..but Objective: Update all the M's to F and all F's to M. will not work...
You must have a very broken version of...
February 19, 2013 at 9:58 am
jdamm (2/19/2013)
As for writing the question,...
February 19, 2013 at 9:56 am
jdamm (2/19/2013)
Vel.Velez (2/19/2013)
In SQL Server 2005, wouldn't this FAIL?--#2 Data
INSERT INTO GenderUpdate (Gender)
VALUES ('M'), ('M'),('M'),('M'),('M'),('M'),('F'),('F'),('F'),('F'),('F'),('F'),('F'),('F'),('F'),('F')
If so, #4 would not get to execute?
Correct - checking my results, my default instance...
February 19, 2013 at 9:55 am
sestell1 (2/19/2013)
Andrew Diniz (2/19/2013)
Carlo Romagnano (2/19/2013)
UPDATE GenderUpdate
SET Gender = CASE WHEN GENDER = 'M' then 'F' ELSE...
February 19, 2013 at 9:52 am
opc.three (2/18/2013)
john.arnott (2/18/2013)
Revenant (2/18/2013)
Ray K (2/18/2013)
The Dixie Flatline (2/18/2013)
CC#
.NET
-Java
Espresso
Cortado
February 19, 2013 at 9:48 am
The phrasing is a bit bizarre.
I guessed that the environment had to be case insensitive (otherwise statement 3 fails and aborts the batch, so statement 4 never happens)....
February 19, 2013 at 5:50 am
Andre Ranieri (2/18/2013)
The WITH LOGIN clause enables the remapping of a user to a different...
February 18, 2013 at 12:55 pm
Four votes so far - only another 38 needed and we'll have an short octet of sixes.
February 18, 2013 at 11:16 am
Viewing 15 posts - 3,721 through 3,735 (of 7,484 total)