January 18, 2005 06:18 PM

Hide Database Changes

Easing database maintenance through abstractions
Rating: (0)
SQL Server Magazine
InstantDoc ID #44729
Most applications start with a clean, clear database model. But over time, the application specifications change. Perhaps a second application starts using the database and you need to add new fields, or one field value becomes a selection of several fields. As your applications' data needs grow and change, you eventually find that you need to change the database schema. But you have a problem: You need to maintain compatibility with existing applications or earlier application versions while supporting new requirements.

Mos...

...This article is for paid Professional Members only.

Already a Professional Member? Please log in now:

NOT A PROFESSIONAL MEMBER? YOU CHOOSE:

Professional Membership

Monthly

Annual

VIP Membership

Monthly

Annual

Add a Comment

It looks to me like the example trigger will only work for a single record isnert. Can you not do multiple record inserts/updates through a view's triggers?

TWINCITIES3/30/2005 2:46:58 PM


You must log on before posting a comment.

Are you a new visitor? Register Here
GOOGLE LINKS
SPONSORED LINKS
FEATURED LINKS