Posted by Greg D. Moore \(Strider\) on 03/02/07 01:31

"SQL Learner" <excelmodeling@gmail.com> wrote in message
news:1172791380.721010.42060@n33g2000cwc.googlegroups.com...
> Hi,
>
> I have a table with 8 millions records. Some of the fields needed to
> be parse and modified. Example, "ABC DEF" will be parsed into two
> fields "ABC" and "DEF". And If there is "123" in the field, if will
> be replaced by "456". For example, "XYZ 123 AAA" will be "XYZ 456
> AAA". Also, update query and append query will be used in the
> project.
>
> Give the above information, what will be a faster database to do this
> - MS-Access 2003 or SQL Server 2000?
>

perl


--
Greg Moore
SQL Server DBA Consulting
sql (at) greenms.com http://www.greenms.com

[Back to original message]