Monthly Archives: November 2011

SQL Server – LTRIM() and RTRIM() Functions

Usage : The TRIM function in SQL is used to remove specified prefix or suffix from a string. This is the most common pattern to remove white spaces. Syntax : LTRIM(str): Removes all white spaces from the beginning of the … Continue reading

Clear IE Browsing History From Batch File

You can clear IE browsing History by following commands Temporary Internet Files RunDll32.exe InetCpl.cpl,ClearMyTracksByProcess 8 Cookies RunDll32.exe InetCpl.cpl,ClearMyTracksByProcess 2 History RunDll32.exe InetCpl.cpl,ClearMyTracksByProcess 1 Form Data RunDll32.exe InetCpl.cpl,ClearMyTracksByProcess 16 Passwords RunDll32.exe InetCpl.cpl,ClearMyTracksByProcess 32 Delete All RunDll32.exe InetCpl.cpl,ClearMyTracksByProcess 255 Delete All – … Continue reading

Missing or corrupted : system32hal.dll

Problem : This is System error which doesn’t allow to load your OS. You may see at start-up screen. Windows could not start because the following file is missing or corrupt: <Windows root>system32hal.dll. Please re-install a copy of the above … Continue reading

post | Comments Off on Missing or corrupted : system32hal.dll November 8, 2011

Calculate date difference using Javascript

Calculating date difference in JavaScript is very easy as in .Net, Java or PHP, but requires a bit different approach. For this post i wrote simple example which can calculate difference between two dates in: days and months. you can … Continue reading

Rename multiple files extensions using bat file

some times it may happen that you need to change your multiple files extensions and make it unavailable to others. you can do it by simple way. suppose you have a folder located at C: in which you have your … Continue reading