Multirow inserts

[Former Member]

Sybase has the ability to make an insertion multi rows? If yes, what version is available? If not, has plans to develop?

[VolkerBarth]

Such a pity that "open database documentation" like this page doesn't list the great features of SQL Anywhere... sometimes the "invisible database" is way too invisible to get its deserved audience:(

[Former Member · Accepted solution]

CREATE TABLE IF NOT EXISTS TEST(
        EMP char(3) NOT NULL,
        COD integer NOT NULL,
        DESCR char(60) NULL,
        PRIMARY KEY (EMP, COD) 
);

INSERT INTO TEST
VALUES ('001',1,'TEST 1'), 
       ('001',2,'TEST 2'), 
       ('001',3,'TEST 3');
       ('001',4,'TEST 4'), 
       ('001',5,'TEST 5'), 
       ('001',6,'TEST 6');
       ('001',7,'TEST 7'), 
       ('001',8,'TEST 8'), 
       ('001',9,'TEST 9');

Thanks a lot.