keep previous column value and modified value with column name?

Question

0.00/5 (No votes)

See more:

Hello All,

I have a table like "tblEmp" and in my table i have some column like "Id","Name"

let inser some data in my table as 1, "Ashok"
If any user change this records as 1,"Ashok Kumar" in place of "Ashok"

So finally we have to show data as -

Column Name- [Name] "Ashok" chnaged from "Ashok Kumar" with modifiedby

So how we show ColumnName, previous Text and ModifyText?

Please suggest?

Posted 23-Dec-13 18:40pm

rummer

Add a Solution

Comments

Starlene 24-Dec-13 0:57am

create a trigger to put the modified column to another table and join the both table with ur primary key

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

JoCodes · Answer 1 · 2013-12-23T19:06:00

You should consider having another table to show the historical /audit trail changed values like "current" data in the parent table or each column that is kept historically in the historical table only. Check latest row to get the current state for the object. Preferred since avoids the problem of duplicate data in your database or having to look at multiple tables for the same data.

Something like

UserTable (user_id, user_name) user_History (history_id, change_datetime, description, username, usernamechanged)//new value can saved here or can be removed since its already in usertable.

Hope this helps...

cigwork · Answer 2 · 2013-12-23T19:11:00

Solution 2

Have a look at this article, especially the section on "after update" triggers.

Triggers -- SQL Server[^]

Posted 23-Dec-13 19:11pm

cigwork

viprat · Answer 3 · 2013-12-23T19:19:00

Solution 3

Hi,

you can use the update trigger.
Please see the below link. It will help you.

http://stackoverflow.com/questions/7796281/sql-triggers-how-do-i-get-the-updated-value[^]

Posted 23-Dec-13 19:19pm

viprat