checking which column got updated

Hi,
I need to know all the columns that got updated in an update query.
for example if col1 and col2 got updated then i should return 1 | 2
=3 or if col1 and col3 got updated then i should get the number 1 | 4
= 5 and so on 1,2,4,8,16... for col1,col2,col3,col4..... respecively.
since these values are to be stored in the same table as the last
column, i am using the instead of update trigger
i tried joining the inserted and deleted tables but i was not able to
formulate a query which did this.

Any help would be great

.

Relevant Pages

  • Re: Change data arround
    ... Base that field of your update query on an expression... ... >with no input masks. ... >I need to convert the numbers into a number field sothey ... >How would I formulate an Update query to do this ...
    (microsoft.public.access.modulesdaovba)
  • Re: How do I add two table values and publish to a third table?
    ... Presumably you do have some way of joining all three tables together: ... then the addition is a simple UPDATE query. ... Tim F ... Prev by Date: ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Update query
    ... Try to post in a SQLServer news group ... Gérard Ducouret ... > I'm trying to write an update query by joining two tables ...
    (microsoft.public.project)
  • Update query
    ... I'm trying to write an update query by joining two tables ... together on a common field and updating the field in one ...
    (microsoft.public.sqlserver.datamining)
  • Update query
    ... I'm trying to write an update query by joining two tables ... together on a common field and updating the field in one ...
    (microsoft.public.sqlserver.msde)
Loading