General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Hi Dan.
>1) The type identifying prefix will prevent reserved-word conflicts;
True, but there are other ways to do that as well, and, in the case of SQL SELECT (which is really one of the few places where reserved words are a problem), you can use quotes around field names to eliminate conflicts.
>2) Type identifiers IMMEDIATELY identify the expected value of a column WITHOUT having to refer to the structure.
True, but IMO they also make the code a little less readable. Frankly, so does Hungarian notation for variables and properties, but in those cases, the benefits outweigh the slight drawback.
As Bruce pointed out, this is one of those religious things where I doubt one developer can change another's mind about <g>
Doug
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only