Professional Web Applications Themes

newB question: related tables question - Microsoft SQL / MS SQL Server

hello i have a data base with 10 tables, i want to automaticaly creat a row in all of the tables wehen i create in the first one. normal table relation didn't work for me , so what are they? what is these relations functionality? i have creted relation between my tables, but when i add a row nothing happems to other tables. shall i user stored procedures for this? thanks in advance...

  1. #1

    Default newB question: related tables question

    hello
    i have a data base with 10 tables, i want to automaticaly creat a row in all
    of the tables wehen i create in the first one.
    normal table relation didn't work for me , so what are they? what is these
    relations functionality? i have creted relation between my tables, but when
    i add a row nothing happems to other tables.
    shall i user stored procedures for this?
    thanks in advance


    Blue man Guest

  2. #2

    Default Re: newB question: related tables question

    You could create a trigger on the primary table and then propagate to all
    the secondary tables. You could also use DRI for this if you are on sql2k.

    [url]http://msdn.microsoft.com/library/en-us/tsqlref/ts_create2_7eeq.asp?frame=true[/url]
    [url]http://msdn.microsoft.com/library/en-us/tsqlref/ts_create2_8g9x.asp?frame=true[/url]

    --
    -oj
    RAC v2.2 & QALite!
    [url]http://www.rac4sql.net[/url]



    "Blue man" <famebluerainyahoo.co.uk> wrote in message
    news:uJY7JprPDHA.2476TK2MSFTNGP10.phx.gbl...
    > hello
    > i have a data base with 10 tables, i want to automaticaly creat a row in
    all
    > of the tables wehen i create in the first one.
    > normal table relation didn't work for me , so what are they? what is these
    > relations functionality? i have creted relation between my tables, but
    when
    > i add a row nothing happems to other tables.
    > shall i user stored procedures for this?
    > thanks in advance
    >
    >

    oj Guest

Similar Threads

  1. Newb question
    By The Eclectic Electric in forum Adobe Acrobat SDK
    Replies: 1
    Last Post: December 27th, 02:35 AM
  2. Question (newb)
    By anand ganatra in forum Macromedia Flash Flashcom
    Replies: 1
    Last Post: September 3rd, 03:04 PM
  3. Perl Related Question
    By Rita in forum PERL Modules
    Replies: 1
    Last Post: November 15th, 05:05 PM
  4. Newb question!!
    By sleeper in forum Macromedia Flash
    Replies: 0
    Last Post: August 6th, 02:22 AM
  5. Help on actionscript, newb question
    By Into The Blue in forum Macromedia Flash Actionscript
    Replies: 1
    Last Post: March 2nd, 05:16 AM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139