Professional Web Applications Themes

alternative way to use trigger - Microsoft SQL / MS SQL Server

Hi all, what is the alternative way to use trigger (insert, delete, update) that have column data type (text)? I don't want to recreate my table. Thanks a lot...

  1. #1

    Default alternative way to use trigger

    Hi all, what is the alternative way to use trigger
    (insert, delete, update) that have column data type
    (text)? I don't want to recreate my table. Thanks a lot
    hngo01 Guest

  2. #2

    Default Re: alternative way to use trigger

    Take a look at Instead of Triggers... they can see text columns. (They are
    doc'd in books on line.)

    --
    Wayne Snyder, MCDBA, SQL Server MVP
    Computer Education Services Corporation (CESC), Charlotte, NC
    www.computeredservices.com
    (Please respond only to the newsgroups.)

    I support the Professional Association of SQL Server (PASS) and it community
    of SQL Server professionals.
    www.sqlpass.org


    "hngo01" <com> wrote in message
    news:01a001c356cc$ddea9000$gbl... 


    Wayne Guest

  3. #3

    Default Re: alternative way to use trigger

    Just a note, you didn't say what version you were using, and Instead of
    Triggers are only available in SQL Server 2000.

    --
    HTH
    ----------------
    Kalen Delaney
    SQL Server MVP
    www.SolidQualityLearning.com


    "Wayne Snyder" <com> wrote in message
    news:uhWth$phx.gbl... 
    community 
    >
    >[/ref]


    Kalen Guest

Similar Threads

  1. PHP alternative for MwSQL
    By Larry Wade in forum MySQL
    Replies: 4
    Last Post: November 28th, 10:06 PM
  2. Alternative to PHP NUke
    By Eric in forum PHP Development
    Replies: 3
    Last Post: July 8th, 03:34 PM
  3. Alternative to die()????
    By Scott in forum PHP Development
    Replies: 4
    Last Post: October 16th, 09:36 PM
  4. Alternative for T.O.A.D.
    By Vinodk in forum Microsoft SQL / MS SQL Server
    Replies: 4
    Last Post: July 10th, 02:45 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