Viewing 15 posts - 2,566 through 2,580 (of 3,348 total)
Mighty (10/13/2010)
My opinion is that none of the answers is correct.SQL Server will return 2.50 and 3.60, not 2.5 and 3.6.
Wrong!
SQL Server will return a result set that consists of...
October 13, 2010 at 1:40 am
Thanks for a good question!
Here in the Netherlands, only one type of rounding is taught in school. The type that Wikipedia calls "away from zero" - you only check the...
October 13, 2010 at 12:54 am
lukus_g (10/12/2010)
Hugo Kornelis, you are a ninja!
True! Well, except for the trendy clothes, the superior stealth, the extreme strength and endurance, the ability to kill without getting killed or caught,...
October 12, 2010 at 4:16 am
Christian Buettner-167247 (10/12/2010)
Looks like it is too complicated 😀
(...)
Notice the 2nd closing square...
October 12, 2010 at 1:25 am
lukus_g (10/12/2010)
so, does the transaction actually run and get rolled back?
No.
The author of the question uses a long explanation to expand on how usefull the possibility to use non-standard characters...
October 12, 2010 at 12:59 am
I got two points for answering a question that tests no useful skill whatsoever? Come on, Steve! Even one point would have been more than enough for this one!
Carlo, thanks...
October 12, 2010 at 12:29 am
Hardy21 (10/11/2010)
Nice question.I think the reason for 'ANSI_NULLS will always be ON' for future version is to make the application behavior consistent.
Any other reason?
Standardisation.
ANSI is a standard among relational database...
October 11, 2010 at 3:20 am
Great question. Thanks, cengland.
In addition to the explanation: "Thorough testing shows this also applies to the IN statement", there is also a logical explanation.
The ANSI standard defines the IN operator...
October 11, 2010 at 3:17 am
sjimmo (10/7/2010)
Hugo
Shame about the (nolock) hints, though. They serve no purpose, and they might lead people to believe that these hints are okay to use. They are not, except in...
October 7, 2010 at 6:39 am
Nice question, though maybe a bit too easy.
Shame about the (nolock) hints, though. They serve no purpose, and they might lead people to believe that these hints are okay to...
October 7, 2010 at 4:27 am
Craig Farrell (10/5/2010)
October 5, 2010 at 2:34 pm
Christian Buettner-167247 (10/5/2010)
In your explanation you have switched from order of rows accross pages to order of pages.
I have not meant that a physical order is imposed on the...
October 5, 2010 at 3:39 am
Christian Buettner-167247 (10/5/2010)
I am not satisfied with the answer, indeed I find it very misleading.
I have to disagree. I am completely satisfiied with the answer, as it is 100% correct....
October 5, 2010 at 2:43 am
Whe I saw this question, my expectation was that most people would get it right - after all, there have already been several questions that basicallly tested the same concept....
October 5, 2010 at 12:28 am
tommyh (10/4/2010)
select datalength(N'hi'), datalength('hi')
gives 2 different results. 4 vs...
October 4, 2010 at 5:48 am
Viewing 15 posts - 2,566 through 2,580 (of 3,348 total)