create table emp (eno int,ename varchar(50),esal money,edoj date,ecity varchar(50));
insert into emp values(1001, 'Ramu', 10000, 10/01/2016, 'Delhi');
Error :
Msg 206, Level 16, State 2, Line 1
Operand type clash: int is incompatible with date
What I have tried:
create table emp (eno int,ename varchar(50),esal money,edoj date,ecity varchar(50));
insert into emp values(1001, 'Ramu', 10000, 10/01/2016, 'Delhi');
Error :
Msg 206, Level 16, State 2, Line 1
Operand type clash: int is incompatible with date