ALTER TABLE dbo.DQFGSDZB ADD flag VARCHAR(5)
UPDATE dbo.DQFGSDZB SET flag=0 WHERE 1=1
INSERT INTO dbo.DQFGSDZB ( OBJECT_ID, DQ, FGS,flag )
SELECT '{'+CONVERT(varchar(36),NEWID())+'}' oid, DQ ,FGS,1 flag FROM dbo.DQFGSDZB GROUP BY dq,fgs
DELETE FROM dbo.DQFGSDZB WHERE flag=0
SQLSERVER删除重复数据
最新推荐文章于 2024-05-25 23:34:25 发布