MS SQL Delete duplicate records

Repeat: I built a table in MS SQL, but for a variety of reasons some records are duplicated
: The record is exactly the same.
: Now I want to delete the duplicates, just keep the first one in the duplicate record.
: I seem to have seen a presentation of Oracle in the database,


SELECT DISTINCT * INTO #table_name table_name
Delete from table_name
SELECT * INTO table_name from #table_name
drop table #table_name

Related to this is the "SELECT INTO" option, which can be used in database properties
dialog box, either hook up this item, or execute in Query Analyzer
Execute sp_dboption ' db_name ', ' SELECT INTO ', ' true '
Open. The default value is off.