Same result
>In order to allow inserts in an IDENTITY column, you have to set
SET IDENTITY_INSERT result_detail ON
>
>
>>I made a copy of a table for backup purposes. I now want to restore from it:
>>
>>
>>insert into result_detail
>> select * from result_detail_old
>>
>>
>>SQL throws:
>>"An explicit value for the identity column in table 'result_detail' can only be specified when a
>>column list is used and IDENTITY_INSERT is ON."
>>
>>I tried SET IDENTITY_INSERT result_detail OFF
>>
Everything makes sense in someone's mind
public class SystemCrasher :ICrashable
In addition, an integer field is not for irrational people