In SQL server, I am trying to insert values from one table to another by using the below query :
delete from tblTable1
insert into tblTable1 select * from tblTable1_Link
I am getting the following error :
Column name or number of supplied values does not match table definition.
I am sure that both table having same structure,column names and same data type:
Please help!