Incorrect syntax near data types

Aliyev777 0
Viewed 24
CREATE TABLE KCustomer(CUS_CODE int,CUS_LNAME varchar(50),CUS_FNAME varchar(50),CUS_INITIAL varchar(50),CUS_RENEW_DATE varchar(50),AGENT_CODE int,)
INSERT INTO KCustomer VALUES(10010, 'Ramas', 'Alfred', 'A', 05-'April'-2018, 502)

Incorrect syntax near data types.

ms-access sql
1 Answers

To extend Jürgen's comment:

CREATE TABLE KCustomer
(CUS_CODE int, CUS_LNAME varchar(50), CUS_FNAME varchar(50), CUS_INITIAL varchar(50), CUS_RENEW_DATE DateTime, AGENT_CODE int)

INSERT INTO KCustomer 
VALUES(10010, 'Ramas', 'Alfred', 'A', #2018-04-05#, 502)
uservDNe0
Related