deleting duplicate records

[vinod]

dear friends,
suppose i've one table, it has only to rows.the two rows are are same as it is.how can i delete one row from that table?


thank you verymuch

[cbellizzi]

SELECT DISTINCT *
INTO #HOLDING
FROM >your table<
GO
TRUNCATE TABLE >your table<
GO
INSERT >your table<
SELECT *
FROM #HOLDING
GO
DROP TABLE #HOLDING
GO

[wappy]

you can add another column of type bigint make it auto increment by setting Identity properties to Yes. then you can mannually delete the row :)

dear friends,
suppose i've one table, it has only to rows.the two rows are are same as it is.how can i delete one row from that table?


thank you verymuch