Posted in June 27, 2008 ¬ 3:27 pmh.Rahmansaher
Just a short SQL script which will allow you to find the mutiple rows with the same values in the same table. I am not going to explain what the query does since its a very straight forward query
PLAIN TEXT
SQL:
SELECT [column_name]
FROM [tablename]
GROUP BY [column_name]
HAVING count(*)> 1
-- OR
SELECT * FROM [TableName] WHERE [ColumnName] IN (
SELECT [ColumnName] [...]
Read the rest of this entry »
Posted in September 27, 2007 ¬ 2:16 amh.Rahmansaher
I sure lot of people might want to use the script where they would want to loop over multiple databases sitting on a Single server. In my case, I had to check for a Login Record in all the databases since the person left the company and we wanted to disable his/her access. SO I wrote simple [...]
Read the rest of this entry »
Posted in September 14, 2007 ¬ 2:46 amh.Rahmansaher
I have been looking so much for this error in Coldfusion MX but could not find any solution to my problem. null null is a very vague exception error which gets thrown once in a while. Below are the steps I did to troubleshoot and one of them did the solved the problem.
1) Apply this [...]
Read the rest of this entry »
Posted in January 8, 2007 ¬ 4:20 pmh.Rahmansaher
I thought it would be beneficial to my blog readers to show some of the Windows RUN Commands which will take you directly to the place you want to go !
To Access.. - Run Command
Accessibility Controls - access.cpl
Add Hardware Wizard - hdwwiz.cpl
Add/Remove Programs - appwiz.cpl
Administrative Tools - control admintools
Automatic Updates - wuaucpl.cpl
Bluetooth Transfer Wizard - [...]
Read the rest of this entry »