Stefano Mainardi wrote:
I tried to make a sql sript run to create tables for a simple test DB; it included drop,create and alter table statements; to make SQL Studio 7.4 to execute multiple statements I followed the instructions I got on the relevant manual for the 7.3 version (I have found none for the 7.4) , i.e. I used comments "\\" at the end of each statement.
Nevertheless it didn't work.
How can I make SQL Studio 7.4 to execute multiple statement?
Are there problems about the max lenght the SQL script must have? I read somewere 16K (not sure anyway).
Each statement has to be separated by // on a line of its own. Like this:
create table foo (name varchar(10)) // create table bar (id int primary key, size int not null) // more statements here... _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
