Dave Watts wrote: > > For example, in a database, you may want to determine the average value of a > column, in a table that has a million rows. The SQL to do this is quite > easy, but by default it will prevent write access to those rows while the > query is running.
Only in MS SQL Server. In databases that use multiversioning (Oracle, PostgreSQL, MySQL/InnoDB, Firebird etc.) writers do not block readers. Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284042 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
