How can I find duplicate rows in SQL Server?

Posted by: jwalin on: January 13, 2009

SELECT
<list of all columns>
FROM
tablename
GROUP BY
<list of all columns>
HAVING
count(*) > 1

Kingsley Tagbo: Thanks for reading and sharing my article. Have a great like ... Kingsley
Bob: Doesn't work with IIS7 (default config on Windows 7 and 2008) because no ADSI anymore.
jwalin: Follow the following steps 1]. open you Page in NOTEPAD. 2]. find the tag 3]. Replace the "body" like body oncontextmenu=”return false;" 4]. Sav

Jwalin Khatri