Business Transactions and SQL Server Transactions
Every business process consists of one or more transactions. Imagine that you are managing an online store. When a customer orders a product, a predefined process must run to guarantee on-time delivery. The process must also include credit card processing to be sure that your company gets paid. If one of these tasks fails and cannot be corrected, the whole process must be canceled to ensure that the customer is not invoiced without getting the product or vice versa. In most cases, these processes are handled by computer systems, where all data is stored in databases. The data related to one business transaction should be changed to be reliable, consistent, and complete in order to map the business ...
Get Microsoft® SQL Server™ 2005: Applied Techniques Step by Step now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
