Re^2: How to Do multiples SQL Insert at one time?

Hi Guys, great advice, really appreciate it.
as i don't really need everything in perl and my main concern is speed. i will try to do the bulk insert using the BCP first. again, thanks!!

Comment on Re^2: How to Do multiples SQL Insert at one time?

Replies are listed 'Best First'.
Re^3: How to Do multiples SQL Insert at one time? by Win (Novice) on Jan 08, 2008 at 14:11 UTC
If you are using MS SQL Server 2K another option might be to generate a Data Transformation Services (DTS) script to introduce a temp table into the database, then use that temp table for the insert. This DTS script can be saved and used from Perl. You can delete this temp table with a T-SQL command like: `if exists(select 1 from INFORMATION_SCHEMA.tables where table_name = ' +Table_with_data') DROP TABLE Table_with_data;` [download]	[reply] [d/l]

Replies are listed 'Best First'.

Re^3: How to Do multiples SQL Insert at one time?
by Win (Novice) on Jan 08, 2008 at 14:11 UTC


if exists(select 1 from INFORMATION_SCHEMA.tables where table_name = '
+Table_with_data') DROP TABLE Table_with_data;
[download]

[reply]
[d/l]