Flexibility decreases as logic increases.
....true but that's exactly what placing the logic in the db is supposed to do...guard the db from the user who only seems hellbent on trying to throw trash in.......has become a tangled web of different logic for different things that are so specific that they can’t be used for anything else..
.....why would you want to use a db designed for a specific application with specific requirements, specific purpose ie..custom built
be used for anything else ?!...when you need to add features that allow you to do business in another country..
....surely something like this would be identified even before the db is a gleam in the developer's eye - isn't this why we suffer through the pain of zillions of meetings with user groups who are determined to contradict each other in their requirements for the same application....?!?!
Mike - when your dad said "..you never have to go out looking for trouble, it will find you on its own.”
...I think he really meant that if you don't use all the wonderful features of sql server to your advantage and design the db accordingly, trouble will not only find you, it may well come chasing after you with a club in hand....
- seriously though, are you saying that no logic should reside in the db or that logic should reside in moderation....couldn't quite get a sense of where you
stand in all this?!?!?!
**ASCII stupid question, get a stupid ANSI !!!**