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 May 10, 2006 ¬ 8:12 pmh.Rahmansaher
Press Win+L to switch to the Welcome screen.
Press Win+L to lock your workstation.
You can switch users without going through the Welcome screen: From Task Manager, go to the Users tab, right-click a user, and select Connect.
Hold down the shift key in the shutdown dialog to change "Stand By" to "Hibernate". Or just press H to [...]
Read the rest of this entry »