Viewing 15 posts - 166 through 180 (of 272 total)
I have a question about this. If the trigger executes once even if no rows are inserted, what happens if 5 rows are inserted at a time. Does...
September 23, 2014 at 8:22 am
JustMarie (9/22/2014)
Made my guess, ran the code, got back NULL. Not an empty record set - NULL.
So, did I. Even though that's what I answered, that's not what...
September 22, 2014 at 8:09 am
dfortier (9/22/2014)
Got me! 🙁
Me, too. I'll blame it on a Monday morning brain.
September 22, 2014 at 8:06 am
Dave62 (8/29/2014)
Thanks for the question Steve!I was hoping one of the answers was going to be "A supervisor who had too much caffeine".
:hehe:
Enjoy!
Love it!
September 2, 2014 at 3:21 pm
Gazareth (8/29/2014)
Easy one, thanks Steve.I think one of the options should have been 'A supervisor of supervisors' though 🙂
+1
September 2, 2014 at 3:20 pm
Hugo Kornelis (8/22/2014)
It won't be updated.
The reason for the shorter maximum length for temp table names is that SQL Server internally adds some characters to the name. That way, you...
August 22, 2014 at 1:55 pm
gbritton1 (8/22/2014)
also means:- Biologically-Inspired Machine Learning
- basketball is my life
- Bentham Institute of Management & Languages
- Burn In My Light
- Battle Information Management Laboratory
- Bureau international de Métrologie légale
...and others
🙂
August 22, 2014 at 9:05 am
Steve Jones - SSC Editor (8/21/2014)
marcia.j.wilson (8/21/2014)
August 21, 2014 at 8:45 am
Ed Wagner (8/21/2014)
Nice question, thanks. But I'm with Koen - I've never used a table name that long and I expect to be beaten by someone if I do.
Amen...
August 21, 2014 at 8:41 am
I've worked with a lot of developers who think they shouldn't have to test. That's QA's job. Their results show it.
My tendency is to believe I have mistakes...
August 21, 2014 at 8:31 am
Totally irrelevant to the discussion, but for some reason, when I first glanced at the title, I read Booze Age Development instead of Bronze Age Development.
August 21, 2014 at 8:30 am
Good job of documenting the reasons for why each answer was right or wrong.
August 20, 2014 at 9:20 am
Julie Breutzmann (8/6/2014)
Did you highlight (select) the table first?
I misunderstood and highlighted the table on object explorer rather than the query. Then I realized what was meant and was...
August 6, 2014 at 8:09 am
pmadhavapeddi22 (8/6/2014)
Hany Helmy (8/6/2014)
August 6, 2014 at 8:02 am
Viewing 15 posts - 166 through 180 (of 272 total)