Professional Web Applications Themes

The simples thing ;) - Microsoft SQL / MS SQL Server

Hi, How to perform such a thing: when column DATE is changed I would like to increse column COUNT (+1). I think that trigger is what I should use, but I can't find such a smiple example in doentaion. I'm very beginer... Than You. JanS...

  1. #1

    Default The simples thing ;)

    Hi,

    How to perform such a thing: when column DATE is
    changed I would like to increse column COUNT (+1). I think
    that trigger is what I should use, but I can't find such a
    smiple example in doentaion. I'm very beginer...
    Than You.
    JanS
    JanS Guest

  2. #2

    Default The simples thing ;)

    Not tested but should work

    create trigger foo on table
    for update (datecolumn)
    as
    update table set count = count+ 1 where ikey in (select *
    from inserted)

    HTH

    Ray Higdon MCSE, MCDBA, CCNA
    >-----Original Message-----
    >Hi,
    >
    >How to perform such a thing: when column DATE is
    >changed I would like to increse column COUNT (+1). I
    think
    >that trigger is what I should use, but I can't find such
    a
    >smiple example in doentaion. I'm very beginer...
    >Than You.
    >JanS
    >.
    >
    Ray Higdon Guest

Similar Threads

  1. ...and another thing...
    By Bob Greenberg in forum Macromedia Flash
    Replies: 0
    Last Post: March 10th, 10:19 AM
  2. Same old thing
    By BoyanM webforumsuser@macromedia.com in forum Macromedia Freehand
    Replies: 0
    Last Post: November 11th, 09:55 AM
  3. simples way to sort a mysql result
    By somaBoy MX in forum PHP Development
    Replies: 5
    Last Post: November 7th, 05:44 PM
  4. One more thing......
    By Econ Dev webforumsuser@macromedia.com in forum Macromedia Fireworks
    Replies: 1
    Last Post: July 10th, 06:43 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