Viewing 15 posts - 1,246 through 1,260 (of 3,348 total)
I missed the most important correct answer: you'll get fired. 😀
Luckily Shane does indicate in the explanation that using this type of table names is not a good idea.
A bit...
December 1, 2015 at 1:18 am
sknox (11/24/2015)
Hugo Kornelis (11/24/2015)
From the answer options I deduced that I...
November 24, 2015 at 12:59 pm
The correct answer is missing: "The table doesn't have a primary key". It's also suspect that all columns are nullable.
From the answer options I deduced that I needed to focus...
November 24, 2015 at 2:14 am
Iulian -207023 (11/23/2015)
Is there a naming convention that you can recommend ?i.e. for user tables tbl_
for user's views vw_
for user's functions f_
for procedures p_
or something like this ...
If you...
November 23, 2015 at 2:01 am
patricklambin (11/20/2015)
Do you agree with the explanations given by the author to reject the sp_ prefix at the beginning of the name...
November 20, 2015 at 11:51 am
Thanks, all, for the kind words!
sipas (11/20/2015)
Nice question, not because it's really necessary to know the names, but for the explanation of where the names come from.
I think that knowing...
November 20, 2015 at 6:04 am
I do not want to go into a mud-slinging contest or in any play on words. I value you as a person, and I value your contributions to this site...
November 18, 2015 at 8:03 am
Jeff Moden (11/17/2015)
Hugo Kornelis (11/17/2015)
November 18, 2015 at 12:50 am
Alan.B (11/16/2015)
This may be one of those cases where is does not depend. Cursors are never the best solution.
Even in pure data manipulation cases, this is not always the case.
On...
November 17, 2015 at 2:11 pm
TomThomson (11/6/2015)
Another excellent question. Will there be a third in the series?
Thanks! And no, this series is now done.
I do have two other questions lined up, though; they will...
November 6, 2015 at 1:03 pm
Sean Lange (11/4/2015)
November 4, 2015 at 12:22 pm
Luis Cazares (11/4/2015)
Some of us prefer to avoid prefixes for most objects. Procedures should just be descriptive on the action they perform. Adding a prefix only slows down coding.
When creating...
November 4, 2015 at 12:14 pm
Tom, KIm: Thanks for all the effort you put in. I plan to run some tests myself now, but that will have to wait a few days until I can...
November 4, 2015 at 7:18 am
michal.lisinski (11/3/2015)
Could anybody clarify me this...
November 3, 2015 at 7:42 am
Viewing 15 posts - 1,246 through 1,260 (of 3,348 total)