>I issued the following:-
>
>insert into yearly1 select * from yearly
>
>I get the following message:-
>Msg 8101, Level 16, State 1, Line 1
>An explicit value for the identity column in table 'yearly1' can only be specified when a column list is used and IDENTITY_INSERT is ON.
>
>SET IDENTITY_INSERT yearly1 OFF
>insert into yearly1 select * from yearly
>
>The following message apper:-
>
>Msg 8101, Level 16, State 1, Line 3
>An explicit value for the identity column in table 'yearly1' can only be specified when a column list is used and IDENTITY_INSERT is ON.

When dealing with identity columns, SQL requires that you specify all of the column names in the insert statement..

insert into yearly1 (columnname1,columnname2,...) select columnname1, columnname2,... from yearly