SQL question

Results 1 to 4 of 4

Thread: SQL question

  1. #1
    santos Guest

    Default SQL question

    i cant find the function in MSSQL7 to make external primary keys, like for example i have four tables and every time there is a new entry in the main one, the other three all add new record and put the id value the same as in the main table. can somebody please help me with this??<BR>

  2. #2
    Join Date
    Dec 1969

    Default Triggers?

    You can apply triggers to tables so that when a record is inserted in your main table the trigger fires off some sql for the other tables. Is this what you mean?

  3. #3
    santos Guest

    Default RE: Triggers?

    ohhhh...so thats what those triggers are for!!<BR><BR>thanks!<BR><BR>and maybe you also know some place where i can look up how to write a trigger?<BR>

  4. #4
    Join Date
    Dec 1969

    Default SQLTeam.com top of page. <EOP>

    end of post

Posting Permissions

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