Trigger

I want to be able to check if column 27 has been updated either on an insert
or an update.
If this column has been updated with a value I want to insert the following
fields into a different table (InvMov) within the database:

StockCode, Warehouse, TrnYear, TrnMonth, EntryDate, TrnQty and Movement Type

How would I go about achieving this? Is it something to do with
COLUMNS_UPDATED? I'm not sure what BOL is telling me.

Thanks


.

Relevant Pages

  • Change link text
    ... Is there a good cross-browser way of ... achieving this? ... Is HTMLAnchorElement a good place to start? ... Prev by Date: ...
    (comp.lang.javascript)
  • Indexes - Fill Factor option...
    ... frequently use in SELECTs or UPDATEs actions. ... BOL tells me that a 100% Fill Factor should not be used on heavily ... Marco. ... Prev by Date: ...
    (microsoft.public.sqlserver.tools)
  • Indexes - Fill Factor option
    ... frequently use in SELECTs or UPDATEs actions. ... BOL tells me that a 100% Fill Factor should not be used on heavily ... Marco. ... Prev by Date: ...
    (microsoft.public.sqlserver.setup)
  • Error 28554:
    ... We are using RDA. ... BOL says "Error 28554: The number of rows at the client does not match the ... Atle ... Prev by Date: ...
    (microsoft.public.sqlserver.ce)
  • FT indexes are not populating
    ... I've created a couple of full-text indexes using the FT wizards and/or sample ... code from BOL. ... Kevin Z ... Prev by Date: ...
    (microsoft.public.sqlserver.fulltext)