Viewing 15 posts - 241 through 255 (of 673 total)
mtillman-921105 (7/5/2011)
SanDroid (7/5/2011)
The insert into the #temp table is executed as a sperate query.
You would need to start with...
July 5, 2011 at 1:52 pm
This was done in a single script, but not a single query.
The insert into the #temp table is executed as a seperate query.
You would need to start with the use...
July 5, 2011 at 1:18 pm
The number one goal of any publicly traded company is to make a larger profit every quarter.
It is currently legal in this country for public and private corporations to extort...
July 5, 2011 at 10:29 am
SQLkiwi (7/5/2011)
David Portas (7/5/2011)
July 5, 2011 at 9:03 am
Eric M Russell (6/30/2011)
Letting SQL Server implicitly do the datatype conversion won't always cut it. For example, is this April 3, 2002 or March 4, 2002? It matters because in...
June 30, 2011 at 3:14 pm
Eric M Russell (6/30/2011)
SanDroid (6/30/2011)
Eric M Russell (6/30/2011)
#1 An address or phone number isn't an...
June 30, 2011 at 2:08 pm
Eric M Russell (6/30/2011)
#1 An address or phone number isn't an attribute or measure of...
June 30, 2011 at 1:21 pm
Steven993 (6/30/2011)
I was saying that the only kind of key is what is called candidate key. We should call candidate key, just key.
Of course a...
June 30, 2011 at 12:34 pm
Steven993 (6/30/2011)
The only key in relational theory is the candidate key. Or just "key". There is no notion of "primary" which indeed come from SQL.
Are you ok? Is this statement...
June 30, 2011 at 12:27 pm
CELKO (6/30/2011)
The Relational Model for Database Management Version 2 by Dr. E. F. Codd Section 1.8 "Key and Referential Integrity" .....
It is always good to see somone at your level...
June 30, 2011 at 10:51 am
How funny. The reprint of this QOTD in the 6/30/2010 rss feed and daily email is still the wrong answer. The answer shows Yes with the explination saying...
June 30, 2011 at 8:53 am
Nice question.
I had to add a question like this to our interview questions after someone kept causing prduction outages by updating values in the wrong database.
June 30, 2011 at 8:06 am
Wow... Nice Introduction paragraph...
I think some links to (or a mention of) external referencesin the article would have helped the points it was making. Two external references...
June 30, 2011 at 7:30 am
FargoUT (6/29/2011)
I assume the answer has been updated, because I see nothing wrong with the question, answer, or explanation.
It has.
June 29, 2011 at 10:36 am
Wow... I understood yesterdays question being caused by bad definition of the Execution Plan concept.
I guess this is another day for a free point. 😛
June 29, 2011 at 7:20 am
Viewing 15 posts - 241 through 255 (of 673 total)