表备份
#判断表是否存在
if exists (select 1 from sysobjects where id = object_id('CARD_HOLDER_BACK') and type = 'U')
BEGIN
#取消自增
set IDENTITY_INSERT CARD_HOLDER_BACK on
#只插入数据
INSERT INTO CARD_HOLDER_BACK(ID, Pan, status, Operatetime, OprateType, DeviceName, userId, batchId) SELECT ID, Pan, status, Operatetime,OprateType,DeviceName,userId,batchId from CARD_HOLDER WHERE ID=21
set IDENTITY_INSERT CARD_HOLDER_BACK off
END
ELSE
#复制表结构和数据
SELECT * INTO CARD_HOLDER_BACK FROM CARD_HOLDER WHERE ID=20