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 '‘'.
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;
0 Comments
Please add nice comments or answer ....