Professional Web Applications Themes

cascade update non-primary key field - Microsoft SQL / MS SQL Server

is it possible to do that except trigger?...

Sponsored Links
  1. #1

    Default cascade update non-primary key field

    is it possible to do that except trigger?


    Sponsored Links
    Calvin Guest

  2. #2

    Default Re: cascade update non-primary key field

    For non key columns you will have to use triggers to do that.

    --
    -Vishal
    "Calvin" <noemailprovided.com> wrote in message
    news:#QsoCVIQDHA.2676TK2MSFTNGP10.phx.gbl...
    > is it possible to do that except trigger?
    >
    >


    Vishal Parkar Guest

  3. #3

    Default Re: cascade update non-primary key field

    Refer to this url
    it has some examples to implement cascaded Deletes/Updates with Triggers.

    [url]http://support.microsoft.com/?scid=kb;en-us;Q142480[/url]

    --
    -Vishal
    "Calvin" <noemailprovided.com> wrote in message
    news:eqrDm3IQDHA.1216TK2MSFTNGP11.phx.gbl...
    > if so, any smart way to write the trigger as i have maintained all
    > relationships between tables.
    >
    > "Vishal Parkar" <vgparkarhotmail.com> wrote in message
    > news:eDymrzIQDHA.2228tk2msftngp13.phx.gbl...
    > > For non key columns you will have to use triggers to do that.
    > >
    > > --
    > > -Vishal
    > > "Calvin" <noemailprovided.com> wrote in message
    > > news:#QsoCVIQDHA.2676TK2MSFTNGP10.phx.gbl...
    > > > is it possible to do that except trigger?
    > > >
    > > >
    > >
    > >
    > >
    >
    >

    Vishal Parkar Guest

  4. #4

    Default Re: cascade update non-primary key field

    Yes, as long as it has a UNIQUE CONSTRAINT.

    --
    Jacco Schalkwijk MCDBA, MCSD, MCSE
    Database Administrator
    Eurostop Ltd.


    "Calvin" <noemailprovided.com> wrote in message
    news:#QsoCVIQDHA.2676TK2MSFTNGP10.phx.gbl...
    > is it possible to do that except trigger?
    >
    >

    Jacco Schalkwijk Guest

Similar Threads

  1. Primary Scratch & Windows Primary Paging file?
    By Tommy Oberst in forum Adobe Photoshop 7, CS, CS2 & CS3
    Replies: 14
    Last Post: April 15th, 10:26 PM
  2. possible to DELETE CASCADE?
    By Miles Keaton in forum PostgreSQL / PGSQL
    Replies: 5
    Last Post: December 30th, 10:42 PM
  3. Update db Field with datagrip
    By dbento webforumsuser@macromedia.com in forum Macromedia Director Lingo
    Replies: 1
    Last Post: October 28th, 11:45 PM
  4. Replies: 1
    Last Post: August 1st, 05:57 PM
  5. Key Field Update
    By Ray Thigpen in forum Microsoft Access
    Replies: 0
    Last Post: July 17th, 03:46 PM

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