SQLServer将一个表内指定列的所有值插入另一个表

insert into records_resolve_bak(resolve_save_addr,resolve_time,resolve_status)
select  resolve_save_addr,resolve_time,resolve_status
from records_resolve order by resolve_time