Viewing 15 posts - 421 through 435 (of 658 total)
Hugo Kornelis (4/13/2012)The syntax used in this question is deprecated
Is it definitely deprecated? The help page doesn't say so, just that the parentheses are optional for backward compatibility and recommends...
April 13, 2012 at 2:20 am
I got it wrong, my reasoning being that disallowing "yes with triggers" would be grossly unfair to those with English as a second language so it must be the correct...
April 10, 2012 at 2:55 am
All three answers are in fact correct.
"Returns from step 4 Returns 5 columns and 2,155 rows of data" is true - it returns 5 columns and also another column.
:Whistling:
April 4, 2012 at 4:20 am
L' Eomot Inversé (3/20/2012)
But the question doesn't say "required to hold the create view statement ... It says "required for the the create view statement"
I've read this several times...
March 21, 2012 at 3:17 am
Koen Verbeeck (3/20/2012)That is the space for the CREATE VIEW statement. That is stored in the sys.sql_modules catalog view. What I'm going after is that extra information is also stored...
March 20, 2012 at 3:31 am
Andrew Watson-478275 (3/16/2012)
Not necessarily. The limit for table size is "how much disk have you got". If your DB is already filling the disk, you could hit the...
March 19, 2012 at 3:20 am
jeff.mason (3/16/2012)
So if you look at this strictly as a syntax issue, the question is sound.
A fair point. Depends whether you thought (rightly) that the question was about forgetting to...
March 16, 2012 at 7:49 am
The correct answer is 'error at line 8', when you run out of disk space, so the closest answer is 'error at line 7'.
March 16, 2012 at 4:36 am
sqlmunkee (3/9/2012)
Even if you hadn't added the constraint to the table, the second program would still fail because there would already be the temp table from the first program.
That's not...
March 9, 2012 at 4:02 am
Got this right as I was hit by it a few weeks ago after an attempt to "tidy up" some code by naming the constraints :blush:
March 9, 2012 at 3:46 am
you can also show the explanation is wrong by changing the where clause to
where s.Stat not in (cast(Null as varchar(20)), 'Idle')
Whenever using Nulls in where clauses, comparisons should use "is...
March 1, 2012 at 2:51 am
Yet another question that tells us not to rely on implicit conversion...
February 29, 2012 at 2:34 am
sknox (2/14/2012)
Obligatory pedantic complaint: they're parentheses, not brackets. These are brackets: []. (For completeness, these are braces: {}.)
Where I come from, () are brackets, [] are square brackets, and {}...
February 15, 2012 at 2:16 am
On Enterprise edition the results are the same - the view index is used.
On both this and Developer edition I get a warning for each statement
"Warning: Index hints supplied for...
February 13, 2012 at 2:36 am
Viewing 15 posts - 421 through 435 (of 658 total)