Search results for sql

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 »

Resume

MUJEEBUR RAHMANSAHER

                                

Solutions-oriented Software Architect and Engineer with broad experience designing, development, configuration, and implementing robust client-focused and internal Web-based systems.

In-depth knowledge of object-oriented technologies.
5+ years extensive experience in Cold Fusion (V5.1, V6.1 and 7.0 MX).
Extensive experience with design and coding using various programming languages such as C, C++, VB and Java.
Extensive experience in usage [...]

Read the rest of this entry »

Some Windows Run Commands

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 »