Viewing 15 posts - 3,601 through 3,615 (of 7,484 total)
david.holley (4/5/2013)
April 6, 2013 at 6:25 am
GilaMonster (4/5/2013)
I...
April 6, 2013 at 5:36 am
Lynn Pettis (4/5/2013)
sql-lover (4/5/2013)
GilaMonster (4/5/2013)
sql-lover (4/5/2013)
April 6, 2013 at 5:25 am
Hugo Kornelis (4/4/2013)
bev.kaufman (4/4/2013)
Okay, then how would you have written a left outer join if you wanted to fetch only the records where the left side had flag = 1?
SELECT...
April 4, 2013 at 12:57 pm
kapil_kk (4/4/2013)
Thanks for the explanation TOM..What about AND if we used in place of WHERE?
You can't use AND in place of WHERE. In a select statement, any AND is...
April 4, 2013 at 12:46 pm
bev.kaufman (4/4/2013)
April 4, 2013 at 12:36 pm
Since I mistakely thought (until I looked a bit harder) that the correct answer wasn't an option, I assumed the missing batch separator was a mistake and picked the 5...
April 4, 2013 at 11:12 am
I had forgotten were not there that the ";" is not alowed in there.
And didn't even notice that THROW would cause an error on three of the...
April 4, 2013 at 9:00 am
I like the question. Not of course the form and wording of the answers (|I won't say more than that as Hugo has covered it fullyHugo) but the...
April 4, 2013 at 5:46 am
KWymore (4/1/2013)
April 1, 2013 at 1:36 pm
Daniel Bowlin (4/1/2013)
Rob Schripsema (3/29/2013)
SQLRNNR (3/29/2013)
JAZZ Master (3/29/2013)
SQLRNNR (3/28/2013)
Cliff Jones (3/28/2013)
bcsims 90437 (3/28/2013)
Terry300577 (3/28/2013)
Cadence
Chirunning
(Just did 4 days of chirunning/chiwalking instructor training, and got the topic of 'cadence' for my practical...
April 1, 2013 at 1:31 pm
Amusing question :-P.
Timeouts can cause rollback, but rollback pays no attention to them if they happen while it is executing - it just ignores it - because...
April 1, 2013 at 5:54 am
Koen Verbeeck (3/29/2013)
WayneS (3/29/2013)
Koen Verbeeck (3/28/2013)
Because someone has to answer all those BI questions...
March 29, 2013 at 3:27 pm
Viewing 15 posts - 3,601 through 3,615 (of 7,484 total)