Viewing 15 posts - 2,161 through 2,175 (of 7,484 total)
crussell-931424 (9/25/2014)
I guess even the BOL has to fix a mistake now and then.
That "even" suggests you haven't noticed how often BOL is wrong :-D.
September 25, 2014 at 5:23 pm
sfrostx (9/25/2014)
Can anyone help me understand why the second and third selects in the following generate an error?
I don't understand it at all. An interesting twist is that whether...
September 25, 2014 at 5:08 pm
Gary Varga (9/11/2014)
Steve Jones - SSC Editor (9/11/2014)
I suspect it's an issue in the query that grabs the post and renders the form rather than the JS.
I'd put my money...
September 25, 2014 at 11:42 am
Ed Wagner (9/25/2014)
ChrisM@Work (9/25/2014)
BWFC (9/25/2014)
Ed Wagner (9/25/2014)Terminator
Colon
Begininator
Platypus
Weevil
September 25, 2014 at 6:40 am
Good question, but two small flaws:
1: the explanation is misleading. It says "The RAND function only produces one value for all calls in a specific connection with a specific...
September 25, 2014 at 6:07 am
sing4you (9/24/2014)
Sean Lange (9/24/2014)
TomThomson (9/24/2014)
Ed Wagner (9/24/2014)
Sean Lange (9/24/2014)
SQLRNNR (9/24/2014)
Ed Wagner (9/24/2014)
SQLRNNR (9/24/2014)
whereisSQL? (9/24/2014)
SQLRNNR (9/24/2014)
BWFC (9/24/2014)
Ouroborosburro de oro
burrito
burr filled dough
Pasta (did someone say dough :-D)
hasta
rasta
Raster
Faster
Plaster
Paris
Judgement
September 24, 2014 at 6:02 pm
Ed Wagner (9/24/2014)
Sean Lange (9/24/2014)
SQLRNNR (9/24/2014)
Ed Wagner (9/24/2014)
SQLRNNR (9/24/2014)
whereisSQL? (9/24/2014)
SQLRNNR (9/24/2014)
BWFC (9/24/2014)
Ouroborosburro de oro
burrito
burr filled dough
Pasta (did someone say dough :-D)
hasta
rasta
Raster
Faster
September 24, 2014 at 2:18 pm
Given the 6th option, it is extremely obvious what the correct answer is - so thanks for the effortless points.
However I was a little suspiciious about the no transformation requirement....
September 24, 2014 at 5:18 am
Lovely article, Gail.
I think "premature optimization is the root of all evil" is the oldest and best known statement that is commonly misinterpreted as a reason for developers not to...
September 23, 2014 at 6:51 pm
Jack Corbett (9/23/2014)
September 23, 2014 at 5:01 pm
Hugo Kornelis (9/22/2014)
This has nothinng to do with the ISNULL being executed or not. The correct explanation would be that the SELECT assigns a value once for...
September 23, 2014 at 8:00 am
Stefan Krzywicki (9/22/2014)
I'm kind of hoping this becomes the new thread.
Ah, all becomes clear. The thread wanted a companion, so it inserted itself between some spam threads to fool...
September 23, 2014 at 7:13 am
SqlMel (9/23/2014)
This is something to consider when using triggers. If you need to execute the code inside the trigger only if it affects some rows, you can use the...
September 23, 2014 at 7:05 am
Tavis Reddick (9/22/2014)
My overall comments had a serious theme but an exaggerated style (intended to balance what I saw as a rather one-sided thread full of (legitimate) DBA concerns.
And my...
September 22, 2014 at 7:21 am
Viewing 15 posts - 2,161 through 2,175 (of 7,484 total)