Professional Web Applications Themes

Columns_updated() - Microsoft SQL / MS SQL Server

This function used when a trigger is fired is sometimes inconsistent with the len of the string returned by Columns_updated(). For example, I receive a length of 0 at times using the Len function as such Len(columns_updated ()). The length that should be returned is 1. Anyone that has something USEFUL to reply, please help !...

  1. #1

    Default Columns_updated()

    This function used when a trigger is fired is sometimes
    inconsistent with the len of the string returned by
    Columns_updated(). For example, I receive a length of 0
    at times using the Len function as such Len(columns_updated
    ()). The length that should be returned is 1. Anyone
    that has something USEFUL to reply, please help !
    Mario Guest

  2. #2

    Default Re: Columns_updated()

    The combination of columns updated and not updated
    happen to create a bit sequence that get interrepted as
    space(s). The len function ignores trailing spaces
    and sometimes that leads to ignoring everything
    (particularly when you only have one byte and that bytes is a space);
    thus, the result is zero -- as designed.

    Instead of using LEN, read about DATALENGTH in BOL.

    Bye,
    Delbert Glass

    "Mario" <org> wrote in message
    news:046f01c3586d$d42e4eb0$gbl... 


    Delbert Guest

  3. #3

    Default Re: Columns_updated()

    ha! seems resonable though very bizarre -- completely agree!

    tell me did you think of it by reasoning only or you've seen it actually
    happening before? :-))

    cheers,
    </wqw>

    "Delbert Glass" <com> wrote in message
    news:phx.gbl... 
    >
    >[/ref]


    Vlad Guest

Similar Threads

  1. Trigger using Len(columns_updated())
    By Mario in forum Microsoft SQL / MS SQL Server
    Replies: 2
    Last Post: August 1st, 11:50 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