Database

for MyList in (SELECT Name FROM Emp) loop
 ...
end loop;

-- Table creation and filling
CREATE TABLE TruncTest (
Column1 int);

BEGIN
   DECLARE @cnt INT;
   SET @cnt = 0;
   WHILE @cnt < 100 BEGIN
      INSERT INTO TruncTest VALUES (@cnt);
      SET @cnt = @cnt + 1;
   END;
END;

SELECT COUNT(*) AS Rows FROM TruncTest;

-- Result:
-- Rows
-- 100

--test truncation
BEGIN TRANSACTION;
TRUNCATE TABLE TruncTest;
SELECT COUNT(*) AS Rows FROM TruncTest;

-- Result:
-- Rows
-- 0

ROLLBACK;

SELECT COUNT(*) AS Rows FROM TruncTest;

-- Result:
-- Rows
-- 100

Nadia Monalisa wrote:

Do you think MS Access is a good choice over SQL Server Compact ?

Nadia Monalisa wrote:

So, by performance, are you suggesting me to use SQL Server COMPACT ?

Microsoft Access (Provider: OleDB)
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\database1.mdb;User Id=admin;Password=;
16377 records 54 seconds, averaging 0.0033 seconds per inserted record.

SQL CE (Provider: SqlCe)
Data Source=C:\MyDatabase1.sdf;
16377 records in 38 seconds, averaging 0.023 seconds per inserted record. 

I are Troll

Nadia Monalisa wrote:

I mean, performance and portability wise.

where a.ID_Field = b.ID_Field (+)