Viewing 15 posts - 3,406 through 3,420 (of 7,484 total)
Jan Van der Eecken (6/14/2013)
dwain.c (6/13/2013)
Sean Lange (6/13/2013)
WayneS (6/13/2013)
dwain.c (6/12/2013)
June 25, 2013 at 1:48 pm
Primo Dang (6/24/2013)
June 24, 2013 at 5:31 pm
Paul White (6/24/2013)
sharath.chalamgari (6/24/2013)
http://support.microsoft.com/kb/295305The author should have included that reference in the explanation instead of guessing at how parsing works (and getting it wrong).
+ rather more than just 1
June 24, 2013 at 9:47 am
Trying to construct the date by concatenating three casts from int to nvarchar() is likely to be somewhat error-prone, and even if you get it right (eliminating spaces, ensuring month...
June 22, 2013 at 1:47 pm
I don't much like the question, because the correct answer is (row locks are never escalated to page locks) is not available as an option. Of course it's easy...
June 21, 2013 at 10:16 am
Hugo Kornelis (6/19/2013)
sqlnaive (6/19/2013)
In a normal scenario it should be considered as the default behaviour for the question which is CI (and not CS).
I disagree, and I'll tell you why.
In...
June 19, 2013 at 11:48 am
Hugo Kornelis (6/19/2013)
or run it as is on a server that was installed with default options on a British OS
We can't do that, as there is no British OS which...
June 19, 2013 at 11:37 am
sknox (6/18/2013)
[Logically = ANY should always be FALSE in this case, because there's nothing to equal. Same with = ALL, right? Well......
...
...
Can anyone explain the results?
It's quite straightforward. ALL...
June 18, 2013 at 1:43 pm
Hugo Kornelis (6/18/2013)
hillsl (6/18/2013)
June 18, 2013 at 3:53 am
Mike Dougherty-384281 (6/17/2013)
I assumed "run successfully" meant "returns what it looks like it should" rather than "without error"
That's what I hope a tester/QA man verifying that SQL Server is doing...
June 17, 2013 at 6:02 pm
I've used a variety of version control systems over the years, including a couple of home-rolled ones back in the days when there were no useful version control systems. ...
June 17, 2013 at 3:25 pm
Steve Jones - SSC Editor (6/17/2013)
June 17, 2013 at 2:25 pm
Richard Warr (6/17/2013)
I wonder how 28 % got it wrong...
As only 6% selected the wrong answer it must be down to not selecting three options. If you don't read the...
June 17, 2013 at 7:40 am
basically this chunk of code
SELECT @Vol = Volume FROM @TestTable
IF @VOL > 0
INSERT INTO @TestTable (Type)
VALUES('OK')
ELSE
INSERT INTO @TestTable (Type)
VALUES('NOTOK')
will insert one row into @TestTable, which will have NULL in the...
June 15, 2013 at 4:01 pm
Viewing 15 posts - 3,406 through 3,420 (of 7,484 total)