Viewing 15 posts - 61 through 75 (of 656 total)
pmadhavapeddi22 (4/6/2016)
i feel double negatives are confusing.
I don't not fail to disagree that your statement is wrong
April 6, 2016 at 5:19 am
George Vobr (3/31/2016)
It just shows that the result with the NULL is the same as 'NULL', nothing more.
I would have expected 'NULL' to be treated as a string with that...
March 31, 2016 at 4:07 am
Carlo Romagnano (3/31/2016)
Without an ORDER BY clause, there isn't no guarantee that the first select returns 2. Any value may be returned.
This ^^^
It probably will always return 2 given the...
March 31, 2016 at 1:51 am
George Vobr (3/30/2016)
Try this:
SELECT TRY_CONVERT(XML, 'NULL');
The others I understand, but not this one!
March 31, 2016 at 1:46 am
Incredible that at the time of writing, only 75% got this right!
February 17, 2016 at 2:58 am
Carlo Romagnano (1/28/2016)
If the column is NULL the constraint CHECK is skipped.
It might be skipped by the SQL engine, I don't know. But logically it's not. It's applied, the outcome...
January 28, 2016 at 8:28 am
Ed Wagner (1/25/2016)[/b]
Interesting. I half-expected this to be covered in Books Online, but it isn't. My guess is that it's because NULL is unknown. If you wanted...
January 25, 2016 at 5:47 am
Again, a good idea, but the choices available meant I only had to think about the first two before I got a unique option.
January 25, 2016 at 2:29 am
samot-dwarf (1/14/2016)
January 14, 2016 at 2:10 am
Rich Mechaber (1/6/2016)
SET LANGUAGE british
SELECT CAST('2003-02-28' AS datetime);
Server: Msg 242, Level 16, State 3, Line 4
The conversion of a char data type to a datetime...
January 7, 2016 at 1:55 am
Aaron N. Cutshall (1/4/2016)
Cut and paste issues hit us all -- even to the experienced.
Especially to the experienced - the inexperienced are more likely to check things afterwards 🙂
January 4, 2016 at 10:32 am
I'm astonished that nobody has mentioned this yet, but option 4 will fail as there is no such column.
Perhaps everyone is using the discussion to learn and share information, rather...
January 4, 2016 at 3:56 am
Typo alert!
Option 4 "I can include deterministic computed columns. "
Explanation of why this is wrong "The computed columns that are deterministic can be included."
Oops :blush:
December 16, 2015 at 1:44 am
julienchappel 38298 (12/13/2015)
December 14, 2015 at 4:16 am
Well I guessed right, but the correct answer is surely that ID is not a valid data type for myID.
December 11, 2015 at 2:38 am
Viewing 15 posts - 61 through 75 (of 656 total)