Question

Msg 102, Level 15, State 1, Line 3
Incorrect syntax near '13'.

This was my query code in server 18

Query 1 - INSERT INTO dbo.CustomerMaster

            (CustomerID,Name,

             EMail, Address,CardNo,CardExpiryDate)

VALUES     (1,'Raj','[email protected]', 'A-121','1222223333','12-12-23'),   (2,'Mac','[email protected]', 'A-321','9898887876’,'13-12-25'), (3,'Alex','[email protected]','B-888','7767676565’,'15-01-24')

Answer 1

Dear Student ,

As per the requirement submitted above , kindly find the below solution.

Error details :

• In the given sql insert statement in line 3 before CardExpiryDate date there is ’, instead of '.
• Same is case with line 4 before CardExpiryDate and hence showing the error.
• Also date should be in the format of yyyy-mm-dd
• hence below is the correct sql statement

Correct SQL insert statement :

INSERT INTO dbo.CustomerMaster
(CustomerID,Name,EMail, Address,CardNo,CardExpiryDate)
VALUES
(1,'Raj','[email protected]', 'A-121','1222223333','2012-12-23'),   
(2,'Mac','[email protected]', 'A-321','9898887876','2013-12-25'),
(3,'Alex','[email protected]','B-888','7767676565','2015-01-24')

NOTE : PLEASE FEEL FREE TO PROVIDE FEEDBACK ABOUT THE SOLUTION.