Posted by JS on 09/27/69 11:16

I am trying to make the following SQL statement, but there seems to a limit
on how long a statement can be:

INSERT INTO CUSTOMER (forename, surname, company_name, title, addressA,
addressB, postal_number, city, country, home_phone, mobile_phone,
work_phone, fax, email, sale_procentage, bank, account_number,
creation_initials, creation_date, creation_reason) values ("test", "test",
"test", etc...);

But I can only enter this much text:

INSERT INTO CUSTOMER (forename, surname, company_name, title, addressA,
addressB, postal_number, city, country, home_phone, mobile_phone,
work_phone, fax, email, sale_procentage, bank, account_number,
creation_initials, creation_date, creation_reason) va


Is there some upper limit? And how do I make a long SQL statement like this?

JS

• Next in forum: Re: How to assign quota on a specific datafile?
• Prev in forum: BULK INSERT Question
• Thread view: How long is a SQL statement allowed to be?

[Reply to this message]