Posted by: newbie69 June 14, 2017
sql question
Login in to Rate this Post:     0       ?        
INSERT INTO SERVICE_TICKET (Ticket_ID, VIN_Number, Customer_ID, Date_Received, Notes)
VALUES (00987, ‘1234567’, ‘1’, ’03/20/2016’, ‘ ’);
INSERT INTO SERVICE_TICKET (Ticket_ID, VIN_Number, Customer_ID, Date_Received, Notes)
VALUES (00986, ‘9876542’, ‘2’, ’02/21/2015’, ‘ ’);
INSERT INTO SERVICE_TICKET (Ticket_ID, VIN_Number, Customer_ID, Date_Received, Notes)
VALUES (00985, ’5684394’, ‘3’, ’05/17/2016’, ‘ ’);



INSERT INTO INVOICE_t (Invoice_Number, Date, VIN_Number, Customer_ID)
VALUES (3456, ’03/20/2016’, ‘1234567’, ‘1’);
INSERT INTO INVOICE_t (Invoice_Number, Date, VIN_Number, Customer_ID)
VALUES (4567, ’02/21/2015’, ‘9876542’, ‘2’);
INSERT INTO INVOICE_t (Invoice_Number, Date, VIN_Number, Customer_ID)
VALUES (5678, ’05/17/206’, ’5684394’, ‘3’);



Tried this but all 6 insert error out
Read Full Discussion Thread for this article