Hello Randall, you wrote : > but I am still > getting the "Invalid End of SQL Statement" Error on this > query, I have > been running the sql through the SQL Studio if that makes any > difference. > Current Query: > > INSERT INTO ans_curusers (user_id, lic_type, inuse, session_id) VALUES > (6, 2, '02/14/2003 10:07:02', 23701) // > > INSERT INTO ans_curusers (user_id, lic_type, inuse, session_id) VALUES > (6, 2, '02/14/2003 10:07:32', 23705)
put the '//' comment signs into their own line, like this : INSERT INTO ans_curusers (user_id, lic_type, inuse, session_id) VALUES (6, 2, '02/14/2003 10:07:02', 23701) // INSERT INTO ans_curusers (user_id, lic_type, inuse, session_id) VALUES (6, 2, '02/14/2003 10:07:32', 23705) regards, Markus Stausberg SAP Labs Berlin > -----Original Message----- > From: Randall Hinton [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, February 19, 2003 6:23 PM > To: [EMAIL PROTECTED] > Subject: Fwd: Sql Syntax Problem, > > > > > > Hello Again, > > I have removed the quotes and added the comment lines > but I am still > > getting the "Invalid End of SQL Statement" Error on this > query, I have > > been running the sql through the SQL Studio if that makes any > > difference. > > > > Current Query: > > > > INSERT INTO ans_curusers (user_id, lic_type, inuse, > session_id) VALUES > > (6, > > 2, '02/14/2003 10:07:02', 23701) // > > > > INSERT INTO ans_curusers (user_id, lic_type, inuse, > session_id) VALUES > > (6, > > 2, '02/14/2003 10:07:32', 23705) > > > > Thanks, > > Randall Hinton > > > > > > You will indeed have to put a // at the end of each > statement (line > > comment). It is used as a separator between multiple > statements but is > > not > > needed when executing a single statement un SAPDB. The "update > > duplicates" > > should be ok though I have never used it myself. > > > > Florian Kaerner > > > > > >> -----Ursprungliche Nachricht----- > >> Von: [EMAIL PROTECTED] > >> [mailto:[EMAIL PROTECTED]]Im Auftrag von Randall > >> Hinton > >> Gesendet: Mittwoch, 19. Februar 2003 00:49 > >> An: [EMAIL PROTECTED] > >> Betreff: SQL Syntax Problem > >> > >> > >> Hi all, > >> I am trying to import a Extremely long SQL script from > MSSQL into SAP > >> and I have found the majority of the things that I have needed to > >> change, it creates the Tables fine but when it tries to do multiple > >> insert commands in succession it gives me an "Invalid END of SQL > >> statement" Error... Is there supposed to be some control > character at > >> the end of the statement....? > > > >> Thanks, > >> Randall Hinton > >> > >> _______________________________________________ > > > > > > _______________________________________________ > sapdb.general mailing list > [EMAIL PROTECTED] > http://listserv.sap.com/mailman/listinfo/sapdb.general > _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
