hi,i have two tables:create table test(id int identity(1,1) not null,name nvarchar(10),time_stamp timestamp)insert into test (name) values ('John')insert into test (name) values ('Bon')insert into test (name) values ('Jovi')and second one "test2", which is identical to "test".What i want is to track:- if there is change on existing data then update- if there are new rows than insert new data to table "test2" from table "test".timestamp would be nice solution. does anyone have any sample on this case, how to start? is there better way to do it?thanks
update/insert based on timestamp field
Posted - 2008-09-30 : 17:01:10
