摘要： 一、删除(多字段)重复记录IF (SELECT object_ID('tempdb.dbo.#Test'))>0 DROP TABLE #Test SELECT IDENTITY (INT,1, 1) AS FID, JobID,FlashTimeINTO #TestFROM HFlashCardRecord WHERE FlashTime between '2004-11-16' a... 阅读全文