Viewing 15 posts - 2,161 through 2,175 (of 7,483 total)
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...
Tom
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...
Tom
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
Tom
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...
Tom
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
Tom
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
Tom
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....
Tom
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...
Tom
September 23, 2014 at 6:51 pm
Jack Corbett (9/23/2014)
Tom
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...
Tom
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...
Tom
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...
Tom
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...
Tom
September 22, 2014 at 7:21 am
GilaMonster (9/22/2014)
Koen Verbeeck (9/22/2014)
Eirikur Eiriksson (9/22/2014)
There are some other topics missing, some points also went missing, all happened more or less at the same time.😎
Iek, now that you mentioned it,...
Tom
September 22, 2014 at 6:38 am
Viewing 15 posts - 2,161 through 2,175 (of 7,483 total)