I keep getting a syntax error when I add a comma between rows
SQL view on access
INSERT INTO GG_Service (ServiceID, ServiceDescription,
PricePerHour)
Values
(
('1', 'Prune Tree', '40') , <---- that
comma is highlighted for a syntax error when removed it says that
it is required
('2', 'Trim medium Tree', '60') );
I keep getting a syntax error when I add a comma between rows SQL view on access INSERT INTO GG_Service (ServiceID, Serv
-
answerhappygod
- Site Admin
- Posts: 899604
- Joined: Mon Aug 02, 2021 8:13 am
I keep getting a syntax error when I add a comma between rows SQL view on access INSERT INTO GG_Service (ServiceID, Serv
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!