how to create triggers with tables having no common coloumns

Discussion in 'SQL Server' started by jitupatil_2007, Apr 16, 2008.

  1. jitupatil_2007

    jitupatil_2007 New Member

    Apr 16, 2008
    Likes Received:
    Trophy Points:
    hi friends i am new to this forum and i want to create a trigger which would read one record from the 1st table match that appropriate digits from the 2nd table and on matching it would save those records in new table and these records will be deleted from second table so that when i search with the new record i won't get the redudant data but the problem i am facing is i am having the tables with no common coloumn in either of the tables and no primary key in any of the table so can any one help me please....

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice