Thanks TomH and MikeS. Set Rowcount is exactly what I am looking for...

-----Original Message-----
From: mike singer [mailto:[Email Address Removed] Monday, August 12, 2002 2:47 PM
To: Fang, Elaine; [Email Address Removed] Re: how to delete a duplicate row?


The set rowcount command can be used to limit the number of rows impacted by
any basic query. Use like below

set rowcount 1
delete table where condition


----- Original Message -----
From: "Fang, Elaine" <Elaine.[Email Address Removed] <[Email Address Removed] Monday, August 12, 2002 2:59 PM
Subject: how to delete a duplicate row?


Hi list,

For a table w/o PK and unique index, how to delete a duplicate row? Is there
any system defined column (e.g. rowid etc) that I can use?

Thanks!
Elaine









---------------------------------------------------------------------
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page