Isaac
Lifelong Learner
- Local time
- Yesterday, 17:38
- Joined
- Mar 14, 2017
- Messages
- 8,852
Humor only database people would understand. Funny enough to be a joke? Not really. Serious db forum? Probably not.
But have you ever gotten to the point of quality control with your code to where you realize that even your COMMENTS should be 'scalable' and portable, if possible?
I have!
But that's because I make a lot of comments, and use a lot of repeatable code.
For example, you might say:
Then later you edit the query, or use it somewhere else, and just to be neat, you have to clean up a lot of references to things like "first" and "second", because they're out of whack now.
But have you ever gotten to the point of quality control with your code to where you realize that even your COMMENTS should be 'scalable' and portable, if possible?
I have!
But that's because I make a lot of comments, and use a lot of repeatable code.
For example, you might say:
SQL:
/*
The FIRST Contains term will include items 1-4 on requestor's list:
*/
Where contains(table.column,'"Term"')
/*
The SECOND Contains term will include items 5-8 on requestor's list:
*/
Where contains(table.column,'"Term2"')Then later you edit the query, or use it somewhere else, and just to be neat, you have to clean up a lot of references to things like "first" and "second", because they're out of whack now.
