Ad Code

What is wrong with this Statement ?

INTO Instructor
VALUES (50, ‘AHMED’, ‘ALEEM’, ‘MS’, 40000, 'ISLD', '15-JAN-2011');


error message received


Msg 102, Level 15, State 1, Line 2
Incorrect syntax near '‘'.



You did not have mentioned column names in this query. See this Example please:

CREATE TABLE Employee ( Emp_id int NOT NULL Primary Key );
Insert into Employee (Emp_id) Values ('20');
Select * from Employee;
Reactions

Post a Comment

0 Comments