Update 2 table records using triggers

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

Update 2 table records using triggers

Author

Topic

ManickMagesh
Starting Member

1 Post

Posted - 2008-01-02 : 23:13:01

Hi good morning have a nice day...,
i need ur help in triggers based query...,
If anyone of u know help me,

I have 2 tables...,
Table1 Table2Key Id
Id M1
Name M2

Now values in that tables look like this:

Table1: Table2:

Key Id name Id M1 M2
1 100 Magesh 100 50 50
2 101 Kumar 101 60 55

Now i want to that "kumar" Id want to 100 and that "Magesh" Id want to 101..,
So i want to update the records using key field...,
While updating the table1 Id and name.., the changes have to update in Table2 records also (Id,m1,m2)...,
How to do that?

Magesh

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-01-03 : 05:34:05

Sorry cant understand what you really want. Can you make it more clear?

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources