Viewing 15 posts - 31 through 45 (of 831 total)
Ah, the old "try to figure out the author's intent via mindreading" question--got to love them! I got the right answer simply by guessing correctly which typo had actually been...
August 3, 2015 at 2:52 am
I totally misunderstood the question--somehow thought it was asking when the CAST would result in TRUE, which it obviously never will. Realised my error when I read the answer. :crying:
July 6, 2015 at 1:33 am
Your Name Here (6/25/2015)
Lesson: Dynamic SQL is dangerous, stupid and just bad form.
Using dynamic SQL without parameterising it is dangerous, stupid and bad form. If the developer in your example...
June 26, 2015 at 2:22 am
jshahan (6/24/2015)
Give them the url to this thread...
Yeah, that'll go down like a lead balloon. How would you react if a colleague sent you a URL where they were discussing...
June 25, 2015 at 1:43 am
ArnoKwetters (6/22/2015)
?I call always use an TOP without an ORDER BY clause.
i.e.
select top 10 object_id from sys.objects
works fine !
Of course it does, because it's not a subquery, which is what...
June 22, 2015 at 2:20 am
When the developer said that using SELECT * means all the data is there for him, ready to use, did you ask him if he also declares 100 integer variables...
June 18, 2015 at 2:07 am
Just guessed, got it wrong--not too surprising since apparently the only way to answer correctly would have been to actually run the operation in SQL server (and also, judging from...
June 4, 2015 at 2:43 am
sanjarani (6/1/2015)and in VB and C programming languages they used to say don't use GO TO.
All of the above in certain circumstances become unavoidable and that is why they...
June 1, 2015 at 2:12 am
Jeff Moden (5/16/2015)About 8 months ago I interviewed a handful of "developers" and a couple of "senior DBAs" that didn't know that ROW_NUMBER() even existed.
Well, to be fair, if all...
May 18, 2015 at 6:48 am
Orlando Colamatteo (5/5/2015)
May 6, 2015 at 1:00 am
Didn't know that FLOAT(10) and FLOAT(24) (e.g. REAL) were equivalent, and had never heard of DOUBLE PRECISION, so ended up with the wrong answer. Still, good question, gave me something...
May 5, 2015 at 3:34 am
We often install Express to support our software on client servers--given the pricing of the full version it just makes sense to do so. The lack of an Agent isn't...
February 27, 2015 at 5:29 am
Yeah, I thought the answer was going to be 10^38 - 1 since that's the max value for a NUMERIC column, and those can be defined as IDENTITY.
January 20, 2015 at 3:13 am
Emil Bialobrzeski (12/10/2014)
i saw lots of people on social sites having problems with:1+1+1+1+1+1+1+1+1+1+1+1x0+1 = ?
most of the answers was 1. So saying Simple may apply differently to others :hehe:
Slightly unfair...
December 10, 2014 at 6:01 am
Mike Hays (11/25/2014)
I could swore that it was sometime in 1975?
So you've never stored a date prior to 1975 in a DATETIME? :blink:
November 25, 2014 at 7:20 am
Viewing 15 posts - 31 through 45 (of 831 total)