Viewing 15 posts - 1 through 15 (of 15 total)
The answers:
A: SET ANSI_NULLS OFF
B: SET ANSI_NULLS OFF
C: SET ANSI_NULL_DFLT_OFF ON
D: SET ANSI_NULL_DFLT_ON ON
A: Same as B
B: Same as A
C: This is...
July 30, 2018 at 1:22 am
Any code before the "WITH STATEMENT" must end with a terminator, which is the semi colon. This prevents errors if this code is placed after other statements in a batch.
July 12, 2018 at 1:13 am
April 3, 2018 at 2:26 am
December 14, 2017 at 2:44 am
Isn't that giving a syntax error about a missing bracket?
December 6, 2017 at 12:39 am
Or at least reread once...
Happens too many times in my opinion.
September 29, 2017 at 2:47 am
A few weeks ago 'Floor' was the right answer as well: http://www.sqlservercentral.com/questions/FLOOR()/160011/
August 22, 2017 at 1:16 am
Again 'typos' in the question (and the answer). Sometimes the 'typo' is there deliberately. So when do we know when this is the case and when not?
June 20, 2017 at 7:48 am
Why is the correct answer and the explanation not in line with each other? Is that not something that can be checked quickly and should be in line before a...
June 15, 2017 at 12:30 am
24 -> x
What does this do?
| April 26, 2017 at 1:40 am RE: Vertical Blocks of CodeIt's a windows feature. Works in notepad and other programs as well. February 15, 2017 at 12:27 am RE: VALUES limitSame as 'Select top 1000' default value. Or 'Edit top 200'. Where does those numbers come from? September 16, 2016 at 1:59 am Viewing 15 posts - 1 through 15 (of 15 total) |