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.
thanks in advance