SET identity_insert off

this is assuming that the id will not exist in the table. If there is a possibility the only other method i know would be to us a field list.

regards,


>want to copy / insert a record into a table from another record from the same table. I'm using
>
>

>insert into statefl select * from statefl where st = 'AL'
>

>
>I get the Identity error.
>Is there such a thing as "except a field"?
>Can you show me how to do this?