Results 1 to 2 of 2

Thread: triggers between 2 tables

  1. 05-18-2003, 03:24 AM #1
    wailwin
    wailwin is offline Registered User
    Join Date
    May 2003
    Posts
    2

    Question triggers between 2 tables

    Hello, everyone. I am sorry I haven't been around for long but I have got this confusion. I haven't been able to set triggers between 2 tables.

    I have got a set of data in 1 table and another set in the other table. I want to set the trigger by comparing the data column from one table to another.

    All I want to know is is ti possible to do it? Because I have been told that I can only set triggers on only one table.

    Any help is much appreciated.

    Thanks in advance.
    Reply With Quote Reply With Quote
  2. 05-18-2003, 04:29 AM #2
    MAK's Avatar
    MAK
    MAK is offline Registered User
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    If you want to just compare why you need trigger?

    trigger is used for insert,update,delete.

    explain in detail please.
    My Site:http://www.mssqlengineering.com
    My Book:http://www.wiley.com/WileyCDA/WileyT...470477288.html
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules