Using Stored Procedures, Views, and Triggers
Server-side processing, which is when you let a server process your queries and the like, is probably a concept you have heard of and is the very topic of this chapter—well, to some extent anyway. I will look into three specific ways of doing server-side processing: stored procedures, triggers, and views. The good thing about server-side processing is that you use the power and resources of your server for processing your queries and thus leave your client free to do other stuff. It’s not always appropriate to do so, but in many cases you can benefit from it.
KeywordsDatabase Server Business Rule Output Window Output Argument Input Argument
Unable to display preview. Download preview PDF.