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

posted @ 2017-03-20 23:04  除除  阅读(1188)  评论(0编辑  收藏  举报