hi all,
am new 4 this trigger db object. i have to update two tables.
This is my problem.
User click update button then its updating in my Supplier master table(Supp_Name,Supp_Add,Supp_mail,Supp_phone).its ok. that same time i need to update that data to Contacts table(ContactName,ContactAdd,ContactMail,CantactPh one).
So how i can do it.
Can u help me to solve this problem. But i didnt use this triggers b4. im new to this db object.
thanks

__________________
MSB

You need a primary key or unique field for updation of the table.
Can you tell me how you define uniqueness of each row?

Cheers,
Prabodh

You don't need a trigger for this... prabodh is correct... just do two updates from the app. In order to do that, you need to know what the primary key of each table is so your code can narrow the update down to a single row.

--Jeff Moden

Yes . i didnt wrote it. Specially have to tell There have another table .tblContact. It has ContactId,SUPP_CODE.
This is a table link.
tblSupplier INNER JOIN tblContacts ON
tblSupplier.ContactId =tblContacts.ContactId INNER JOIN
SUPPLIER_MASTER ON tblSupplier.SUPP_CODE =SUPPLIER_MASTER.SUPP_CODE

Sorry. i didnt sent those.
can u explain it again
thanks Prabodh

No Jeff. I think i have to use Trigger. Cause of There My SupplierMaster table data load from Factory. I didnt do any to that table. but im using there datas. that is a problem.

Based on the limited information above, it looks like you have two choices. We need to know the relationship between the two tables, Supplier and Contact. We can make assumptions, but they might be wrong. However, based on the information above, it looks like you can do one of the following:

1) You can do two updates from the application like Jeff suggests. This is can be done by inserting first into the primary table, grabbing the newly created ID, and then using that to insert into the second table.

2) A trigger will also work. Triggers can be created by using the CREATE TRIGGER statement. Look up Triggers in BOL and they will walk you through creating triggers. There are three types, INSERT, UPDATE, and DELETE. The general syntax is as follows:

CREATE TRIGGER <name>
ON <tablename>
AFTER INSERT
AS
  //do stuff
GO

Hope this helps...

Scott Klein
Author - Professional SQL Server 2005 XML
http://www.wrox.com/WileyCDA/WroxTit...764597922.html

Sorry for belated response. I was little busy off-late.
If above responses haven't helped much then below is sample trigger that will synchronize terr_copy table with territories. You can amend it as per your need.


CREATE TRIGGER tr1 ON [dbo].[Territories]
FOR INSERT, UPDATE, DELETE
AS
Begin
-- Update or delete record.
If Exists(select * from deleted)
Begin
  If Exists(select * from Inserted)
      Update terr_copy
         SET id = TerritoryId,
    detail = TerritoryDescription,
    x = RegionId
    from terr_copy inner join inserted on id = TerritoryId
    where id = territoryid
  Else
       Delete terr_copy
    from terr_copy inner join deleted on id = TerritoryId
    where id = territoryid
End
-- Add NEW record.
else
      INSERT INTO terr_copy
         SELECT * FROM inserted

End




Cheers,
Prabodh