Incorrect syntax near ','.

• wapunga

  SSC Enthusiast

  Points: 178

  More actions

  April 15, 2021 at 6:02 pm

  #3871707

  Hi all I'm new to sql server 2019, so any help would be greatly appreciated.

  I'm trying to enter values for a table i have created. Please see attachment. Can anyone see why I'm getting this error

  Attachments:

  You must be logged in to view attached files.

• frederico_fonseca

  SSCoach

  Points: 16225

  More actions

  April 15, 2021 at 6:17 pm

  #3871711

  try values instead of value

   

• Ant-Green

  SSC Guru

  Points: 113543

  More actions

  April 15, 2021 at 7:20 pm

  #3871734

  Also missing the comma between the surname and the date of birth

• Ant-Green

  SSC Guru

  Points: 113543

  More actions

  April 15, 2021 at 7:21 pm

  #3871735

  Employment date is also the wrong format, extra 0 it would seem 20018 guessing should be 2018

• wapunga

  SSC Enthusiast

  Points: 178

  More actions

  April 16, 2021 at 2:27 pm

  #3872043

  Thanks very much this worked

• wapunga

  SSC Enthusiast

  Points: 178

  More actions

  April 16, 2021 at 2:28 pm

  #3872044

  Thanking you

• wapunga

  SSC Enthusiast

  Points: 178

  More actions

  April 16, 2021 at 2:28 pm

  #3872045

  Thank you