June 22, 2011 at 10:22 pm
good morning to all
i have 4 tables like
table1: create table plans(firstname varchar(10))
table2: create table progress(lastname varchar(10))
table3: create table combination(firstname varchar(10),lastname varchar(10))
table4:create table combination1(firstname varchar(10),lastname varchar(10))
now my requirement is
if any name entered into table1,table2 those columns should automatically inserted into table3.so that insertion ,deletion,updation is automatically stored into table3.
but in table 4 we have to store only inserted records from table1,table2.
kindly solve it as early as possible
June 23, 2011 at 1:15 pm
Sounds like an auditing task.
Assuming you're using SS2K5 (as indicated by the forum you posted in), you might want to consider a trigger concept using the data from the internal tables INSERTED and DELETED.
As a side note:
kindly solve it as early as possible
We're not here to do your work. That's usually called consulting or outsourcing and involves money ... 😉
You still need to resolve the issues handed to you. All we can do is point you in the right direction or verify what you've done and if it can be improved.
Another side effect of such a request: some folks will simply move on to the next question...
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply