sqlserver解决标题报错如下:注意需要列名
set identity_insert xxx on;
insert into xxx (msrid
,msrhuhao
,msrwxid
,feeid
,msrtype
,msrcontent
,msrcontenthidden
,msrtime
,msrman
,msrsuccess
,readytime
,msrremark
,infoid
,uuid
,evaluate
,satisfaction
,evaluatetime)
select msrid
,msrhuhao
,msrwxid
,feeid
,msrtype
,msrcontent
,msrcontenthidden
,msrtime
,msrman
,msrsuccess
,readytime
,msrremark
,infoid
,uuid
,evaluate
,satisfaction
,evaluatetime from xxx where msrtime<'2022-01-01';
set identity_insert xxx_history off;