Monthly Archives: March 2009

How to enable Registry Editor Tool

flattr this!

I had a problem yesterday where I got a virus in my Desktop PC (running Windows XP). It disabled the Registry Editor Tool (regedit.exe) to stop the user (thats me) from going and manually editing/deleting registry entry.

This useful command helped me enable Registry Editor. Just click on Start->Run and then type the following in (all as one line):

REG add HKCU\Software\Microsoft\Windows\
CurrentVersion\Policies\System /v DisableRegistryTools /t
REG_DWORD /d 0 /f

Hope this is useful to someone too ;)

Select duplicate rows from a table

flattr this!

Every now and then you might want to see rows which are duplicate (or appear more than once in a table). For example, in a table of ZIP codes, you will not want the ZIP codes to be repeated and the query below will help you in finding any duplicates:

SELECT DISTINCT column_name
FROM table_name
GROUP BY column name
HAVING COUNT(column_name) > 1

Brilliant or what ;)