Re: Copy a record in the same table.

philippe.leblond_at_biodiv.org
Date: 01/21/05 

Date: 21 Jan 2005 12:11:24 -0800

You can also do the following:

select * into #tmp from tablea where id=3
alter table #tmp drop column id
sp_executesql 'insert into tablea select * from #tmp'