I know there aren't arrays in SQL Server... Dunno about Oracle. From what I understand, a 2-dimensional array is a table, so there's never been a need for array vars in sql server. And in sql server, you can have table variables which behave like temprary tables but are stored in memory, which further makes them behave more like normal arrays.
-----Original Message----- From: Casey C Cook [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 08, 2003 12:01 PM To: CF-Talk Subject: Array vs. temp table Under what circumstances would you use an array vs. a temp table in a programming language such as PL\SQL. is there really a difference? CC ---------------------------------------------------------------------------- ------------ This is a PRIVATE message. If you are not the intended recipient, please delete without copying and kindly advise us by e-mail of the mistake in delivery. NOTE: Regardless of content, this e-mail shall not operate to bind CSC to any order or other contract unless pursuant to explicit written agreement or government initiative expressly permitting the use of e-mail for such purpose. ---------------------------------------------------------------------------- ------------ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4