Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
tehprince
Starting Member
9 Posts |
 Posted - 2008-02-28 : 17:39:00
|
| I have the following insert statement from phpmyadmin which I need to execute on sql server 05:INSERT INTO clientgymlink (clientid, gymlocationid) VALUES(61, 1),(62, 1),(63, 2),(64, 3),(90, 4);However I receive the following error: "unable to parse query text".How do I need to reformat this query to be able execute it within sql server?Thanks! |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-02-28 : 17:42:43
|
INSERT INTO clientgymlink (clientid, gymlocationid) VALUES (61, 1)INSERT INTO clientgymlink (clientid, gymlocationid) VALUES (62, 1)INSERT INTO clientgymlink (clientid, gymlocationid) VALUES (63, 2)INSERT INTO clientgymlink (clientid, gymlocationid) VALUES (64, 3)INSERT INTO clientgymlink (clientid, gymlocationid) VALUES (90, 4)
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
tehprince
Starting Member
9 Posts |
Posted - 2008-02-28 : 18:36:17
|
quote:
Originally posted by Peso
INSERT INTO clientgymlink (clientid, gymlocationid) VALUES (61, 1)INSERT INTO clientgymlink (clientid, gymlocationid) VALUES (62, 1)INSERT INTO clientgymlink (clientid, gymlocationid) VALUES (63, 2)INSERT INTO clientgymlink (clientid, gymlocationid) VALUES (64, 3)INSERT INTO clientgymlink (clientid, gymlocationid) VALUES (90, 4)
E 12°55'05.25"N 56°04'39.16"
I still receive the same error, "unable to parse query text".I don't have to execute each insert statement separately do I? I have many more I need to do and it just will take too long. |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-02-29 : 02:33:52
|
No, you don't have to execute each line separately.I still don't understand the reason for you to get the error message.
E 12°55'05.25"N 56°04'39.16" |
|
|
|
|
|
|
|
|
insert statement from phpmyadmin won't execute