2 votes

T-SQL Que signifie le message d'erreur Msg 10709,

Voici mon code et j'ai ajouté les mêmes lignes pour qu'elles correspondent, mais pourquoi l'erreur persiste-t-elle ?

Use KudlerFineFoods
INSERT INTO Employee (Lastname,Firstname,[Address],City,[State],TelephoneAreaCode,TelephoneNumber,EmployerInformationReport,HiredDate,Salary,Gender,Age,JobTitleID)

VALUES 
('Edelman','Glenn','175 Bishop Lane','La    Jolla','CA','619','5550199','https://ecampus.phoenix.edu/secure/aapd/CIST/VOP/Business/Kudl er2/intranet/docs/Glenn%20Edelman%202004.pdf','07/10/2003','$21,500','m','1979/12/01',4),
 ('McMullen','Eric', '763 Church Street','Lemon Grove','CA','619','5550135', 'https://ecampus.phoenix.edu/secure/aapd/CIST/VOP/Business/Kudler2/intranet/docs/Eric%20McMullen%202004.pdf',
  '2002/11/01','13,500.00','m','1992/01/01',3),
('Slentz','Raj', '123 Torrey Drive','North Clairmont','CA','619','5550123','https://ecampus.phoenix.edu/secure/aapd/CIST/VOP/Business/Kudler2/intranet/docs/Raj%20Slentz%202004.pdf','2001/06/01','48,000.00','m','1978/02/04',2),
 ('Broun','Erin', '2045 Parkway Apt 2BY','Encinitas' ,'CA','760','555','5550100', 'https://ecampus.phoenix.edu/secure/aapd/CIST/VOP/Business/Kudler2/intranet/docs/Erin%20Broun%202004.pdf','2003/12/03','$10,530.00','f','19880201',3),
 ('Carpenter','Donald', '927 Seond Street', 'Encinitas','CA', '927','5550154','https://ecampus.phoenix.edu/secure/aapd/CIST/VOP/Business/Kudler2/intranet/docs/Donald%20Carpenter%202004.pdf','2003/11/01','$15,000.00','m','1995/01/01',9),
 ('Esquivez','David','1083 N. Coast HWY Apt 902','Encinitas','CA','760','5550108','https://ecampus.phoenix.edu/secure/aapd/CIST/VOP/Business/Kudler2/intranet/docs/David%20Esquivez%202004.pdf','2003/07/25','$18,500.00','m','1991/01/01',8),
 ('Sharp','Nancy', '10793 Montecino Road','Domona','CA','858','5550135', 'https://ecampus.phoenix.edu/secure/aapd/CIST/VOP/Business/Kudler2/intranet/docs/Nancy%20Sharp%202004.pdf','2003/07/12','$21,000.00','f','1992/07/07',4);

1voto

CloudyMarble Points 16155

La HiredDate dans la 1ère colonne a une syntaxe différente :

'07/10/2003'

Et la rangée Broun a '555','5550100' tandis que le '555' est une donnée supplémentaire comparée aux autres lignes

Prograide.com

Prograide est une communauté de développeurs qui cherche à élargir la connaissance de la programmation au-delà de l'anglais.
Pour cela nous avons les plus grands doutes résolus en français et vous pouvez aussi poser vos propres questions ou résoudre celles des autres.

Powered by:

X