We help IT Professionals succeed at work.
Get Started

Comparing existing row with the new one

e106199 asked
Last Modified: 2010-03-19
Hi all,
i have a webform for collecting data. Data is kept in ms sql 2000 server and here is what i want.
I never update a row, if a row is loaded in the webform, updated and sent back to server i simply create a new version. And i want to keep the log of changes in a column. I dont want to do this with programming because its a lot of work. How can i do this on the database server side(maybe some kind of trigger or stored procedure)?

 And in addition to this if no updates happened i dont want to create a new version.
Right now all data is send as a stored procedure parameter from my web form.

So basically all data will be sent to database server as stored procedure parameters, some function or another procedure will check these values with the columns of the latest version; if there are some updates the insert will procecss and a "changes log" will be created , if there is no update "insert" will be ignored.

Any ideas?
thanks in advance

Watch Question
This problem has been solved!
Unlock 1 Answer and 13 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE