[SQL]消除重复的数据
摘要:
DECLARE @t TABLE( id_num INT IDENTITY(1,1) UNIQUE CLUSTERED, i INT)INSERT INTO @t(i)SELECT 1 UNION ALLSELECT 1 UNION ALLSELECT 1 UNION ALLSELECT 2 UNION ALLSELECT 2 UNION ALLSELECT 3DELETE @tFR... 阅读全文
posted @ 2004-10-11 09:39 Goodspeed 阅读(1204) 评论(0) 推荐(0) 编辑