Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
MorrisK
Yak Posting Veteran
83 Posts |
 Posted - 2009-07-21 : 09:43:51
|
| I'm trying to determine the best way to document query criteria so that it is easily accessable to others who may need it. For example, in our database there is a JobMaster table. Jobs that are still open (not complete) are identified by 'N' in the Complete column. So anyone who needs to query open jobs would write the WHERE clause like this - WHERE Complete = 'N'.First of all, what would you call this? Data dictionary doesn't sound correct. We've already got a data dictionary that describes the tables and columns, data types, etc. Maybe "Query Reference"? "Query Criteria Documentation"(sounds too long). "Business logic"(not sure about that one).Also, where is the best place to put it? Somewhere in a database, a special database for this purpose maybe? In a Word doc? How about SharePoint?Any suggestions are welcome.Thanks,Kevin |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2009-07-21 : 09:59:20
|
| Data logic.If you have sharepoint, put it there as it is easier when it is updated. |
 |
|
|
|
|
|
Query criteria documentation