Syntaxe incorrecte près insérer

Je suis un étudiant, c'est les devoirs...
Les tableaux sont là, mais les données ne sont pas insérées.

Merci pour tous les conseils

Msg 156, Level 15, State 1, Line 181
Incorrect syntax near the keyword 'INSERT'.
USE Mort;
Go
INSERT INTO 
Employee 
(Last_name,
First_name,
Address,
City,
State,
Telephone_area_code,
Telephone_number,
Job_title,
Hire_date,
Wage,
Gender, 
Race,
Age)
VALUES 
('McNamara',
'Juanita',
'923 Parkway',
'La Jolla',
'CA',
'619',
'555-0208',
'Accounting Clerk',
'10/07/2003',
'$12.75',
'F',
'Hispanic',
32);
INSERT INTO 
Employee 
(Last_name,
First_name,
Address,
City,
State,
Telephone_area_code,
Telephone_number,
Job_title,
Hire_date,
Wage,
Gender, 
Race,
Age)
VALUES
('Stephens',
'Harvey',
'7863 High Bluff Drive',
'La Jolla',
'CA',
'619',
'555-0123',
'Dir. of Fin.
& Acct.',
'3/1/1998',
'$75,000.00',
'M',
'Caucasian',
51);
INSERT INTO 
Employee
(Last_name,
First_name,
Address,
City,
State,
Telephone_area_code,
Telephone_number,
Job_title,  
Hire_date,  
Wage,       
Gender,     
Race,           
Age)
VALUES
('Vu',
'Matthew',
'981 Torrey Pines Road',
'La Jolla',
'CA',
'619',
'555-0138',
'Computer Support Specialist',
'8/16/2000',
'$18.50',
'M',
'Asian',
26);
INSERT INTO 
Employee 
(Last_name,
First_name,
Address,
City,
State,
Telephone_area_code,
Telephone_number,
Job_title,
Hire_date,
Wage,
Gender, 
Race,
Age)
VALUES 
('Nguyen',
'Meredith',
'10583 Arenas ST. ',
'La Jolla ',
'CA',
'619',
'555-0102',
'Computer Support Specialist ',
'9/27/1998 ',
'$21.50 ',
'M',
'Caucasian',
25);
INSERT INTO 
Employee 
(Last_name,
First_name,
Address,
City,
State,
Telephone_area_code,
Telephone_number,
Job_title,
Hire_date,
Wage,
Gender, 
Race,
Age)
VALUES 
('Avery',
'Ledonna',
'198 Governor Dr.',
'Del Mar',
'CA',
'619',
'555-0135',
'Asst. - Bakery & Pastry',
'3/28/2003',
'$10.50',
'F',
'African American',
23);
INSERT INTO 
Employee 
(Last_name,
First_name,
Address,
City,
State,
Telephone_area_code,
Telephone_number,
Job_title,
Hire_date,
Wage,
Gender, 
Race,
Age)
INSERT INTO 
Employee 
(Last_name,
First_name,
Address,
City,
State,
Telephone_area_code,
Telephone_number,
Job_title,
Hire_date,
Wage,
Gender, 
Race,
Age)
VALUES 
('Drohos',
'Craig',
' ',
'Selano Beach',
'CA',
'619',
'555-0202',
'Assistant Manager',
'6/15/2000',
'$51,000.00 ',
'M',
'Caucasian',
32);
INSERT INTO 
Employee 
(Last_name,
First_name,
Address,
City,
State,
Telephone_area_code,
Telephone_number,
Job_title,
Hire_date,
Wage,
Gender, 
Race,
Age)
VALUES 
('Meier',
'Elaine',
'9703 Orchid Lane',
'Del Mar',
'CA',
'858',
'555-0112',
'Cashier',
'9/10/2000',
'$10.25',
'F',
'Asian',
51);
INSERT INTO 
Employee 
(Last_name,
First_name,
Address,
City,
State,
Telephone_area_code,
Telephone_number,
Job_title,
Hire_date,
Wage,
Gender, 
Race,
Age)
VALUES 
('Quillian',
'Stanley',
'98542 Wandering Road Apt 2-B',
'Del Mar',
'CA',
'760',
'555-0198',
'Asst. - Butchers & Seafood Specialists',
'12/16/1999',
'$11.50 ',
'M',
'American Indian',
29);
INSERT INTO 
Employee 
(Last_name,
First_name,
Address,
City,
State,
Telephone_area_code,
Telephone_number,
Job_title,
Hire_date,
Wage,
Gender, 
Race,
Age)
VALUES 
('Tyink',
'Thomas',
'87592 Pacific Heights Blvd.',
'Del Mar',
'CA',
'858',
'555-0159',
'Asst. - Bakery & Pastry',
'5/1/2001',
'$9.50',
'M',
'African American',
32);
INSERT INTO 
Employee 
(Last_name,
First_name,
Address,
City,
State,
Telephone_area_code,
Telephone_number,
Job_title,
Hire_date,
Wage,
Gender, 
Race,
Age)
VALUES 
('Vance',
'Brent',
'927 Cynthia Lane Parkway',
'Del Mar',
'CA',
'858',
'555-0147',
'Bagger - 30 hours/wk',
'3/29/2001',
'$6.75',
'M',
'Caucasian',
22);
  • double possible de syntaxe Incorrecte près insert
  • Puisque celui-ci est mis en forme un peu mieux, j'ai déjà voté pour fermer l'autre question.
  • Veuillez indiquer la base de données et base de données que vous utilisez.
InformationsquelleAutor rhonda | 2010-07-07
  1. 5

    Vous avez un INSERT INTO Employee... là sans VALUES clause (L'un après l' "Ledonna")

    Remarque si vous double-cliquez sur le message d'erreur dans la Gestion de Studio, il devrait vous prendre pour le problème de bits de code.

    • J'utilise Microsoft sql server
    InformationsquelleAutor Martin Smith
  2. 2

    Il est votre problème:

    INSERT INTO 
Employee 
(Last_name,
First_name,
Address,
City,
State,
Telephone_area_code,
Telephone_number,
Job_title,
Hire_date,
Wage,
Gender, 
Race,
Age)
INSERT INTO 
Employee 
(Last_name,
First_name,
Address,
City,
State,
Telephone_area_code,
Telephone_number,
Job_title,
Hire_date,
Wage,
Gender, 
Race,
Age)
VALUES 
('Drohos',
'Craig',
' ',
'Selano Beach',
'CA',
'619',
'555-0202',
'Assistant Manager',
'6/15/2000',
'$51,000.00 ',
'M',
'Caucasian',
32);

    Regarder le message d'erreur à la ligne 181.

    Vous avez besoin d'avoir des valeurs d'une instruction insert.

    InformationsquelleAutor fire.eagle
  3. 0

    Vous avez manqué un bloc de valeur:

    Hire_date,
Wage,
Gender, 
Race,
Age) -- MISSING VALUES HERE
INSERT INTO -- THIS IS LINE 181
Employee 
(Last_name,
First_name,
Address,
City,
State,
Telephone_area_code,
Telephone_number,

    trouver le "Aller à la ligne" option dans votre éditeur, il vous aidera à trouver la mauvaise ligne

    InformationsquelleAutor eric