Search results for Multiple Select

How to find multiple/duplicate rows with the same value

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 »

How to write a CURSOR loop over multiple databases in MSSQL 2000

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 »

Some Windows Shortcut Tips !

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 »