declare @cols varchar(max), @query varchar(max);
SELECT @cols = STUFF ( ( SELECT DISTINCT '], [' + name FROM sys.columns where object_id = ( select top 1 object_id from sys.objects where name = 'tbl_lapkehoach_chitiet' ) and name not in ('id') FOR XML PATH('') ), 1,2,'' ) + ']';
SELECT @query = 'insert into tbl_lapkehoach_chitiet(' + @cols+ ') select ' + @cols + ' from tbl_lapkehoach_chitiet where id=24'
EXEC (@query);