2 added 11 characters in body
source | link

select convert(int, id) as id, val into copy_from_with_id_without_id from with_id;

select convert(int, id) as id, val 
into copy_from_with_id_without_id 
from with_id;

will remove identity  .

(downside The downside is that idid becomes nullable but you could add that constraint).

select convert(int, id) as id, val into copy_from_with_id_without_id from with_id;

will remove identity  

(downside is that id becomes nullable but you could add that constraint)

select convert(int, id) as id, val 
into copy_from_with_id_without_id 
from with_id;

will remove identity.

The downside is that id becomes nullable but you could add that constraint.

1
source | link

select convert(int, id) as id, val into copy_from_with_id_without_id from with_id;

will remove identity

(downside is that id becomes nullable but you could add that constraint)