Oracle Trigger to Log column level changes of Table

The requirement was to log changes to columns on any table to a common table. The information to be recorded was Table Name, Column Name, Action (Deletion, Insertion, and Modification), Old Value, New Value, Modified User, Modified Time and Modified PC.

The solution I came up with is to create the triggers on table using a script that trigger that fires on Update Delete and Insert. This trigger sends the information to a function that checks for changes. In the function if there are changes it will be logged to the Audit table. When calling the function I checked for the ‘Action’ and according to that change the information send to it.

How to prevent user from double clicking button on a web application

I faced with situations where users click a button on a web application, and before the request was processed and response comes to the client user clicks again. This may produce inconsistent and unexpected results. A calculation will be performed twice or an entry is posted twice.

In order to prevent this I used was disabling the button until the response using java script.

Merry Christmas

Wish you all Peaceful & Joyful Christmas !!!

How to Insert Data in Text file to SQL Database

Problem:

Insert large amount of data in text file to a SQL database table with minimum time.

 

Solution:

Using ‘Bulk Insert’ is the solution.

I had to import large amount of data in text file to SQL database. If I programmatically insert this data, it would take more time and memory. Therefore, I use SQL bulk insert to import this data. If the fields in the data files are separated using a special character (comma – ‘,’) they can be directly insert in to columns in the database with one query. In addition, it can be fields are not separated, but have known lengths. Then you have to substring them according to lengths.

How to Import data in Excel sheet to SQL Express Database using AD-HOC Query

This something I got to do, Import data in Excel 2007 sheet to table in MS SQL database in SQL Express 2005. So I'm blogging it anyone who need can quickly get it done.
Here are the details you need to know:
Excel File: D:\MyTable.xls
Excel Sheet: Sheet1
SQL database: NewTestDB
Database Table: TestTable (This doesn't exist yet)

How to Install Age of Empires Online / NFS World to Drive other than System Partition

I was installing Age of empires Online on my PC. My system partition (C:\) was almost full. So i installed it on another drive. But by default it download the game files (patch files) to User's home folder ("C:\Users\UserName\AppData\Local\Microsoft\Age of Empires Online") to prevent the any privilege issues. But its about 4 GB of Data. And they don't offer any option to download them to another drive. So I have to find a solution to this. This is how I did it, and I am sharing it you all as it would become useful to every one.

Urban Nature