Database

eg_Anubhava wrote:

And I want to use it Application to For Multi User Support.

I are Troll

eg_Anubhava wrote:

So i want to use the Fee and Small Size database.

eg_Anubhava wrote:

So please suggest me what database to use for my application.

I are Troll

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 ?