Re: How to find only updated columns in a trigger.
From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 03/17/04
- Next message: Adam Machanic: "Re: How to find only updated columns in a trigger."
- Previous message: Johnmichael Monteith: "Append One Table To Another"
- In reply to: Gopinath Munisifreddy: "How to find only updated columns in a trigger."
- Next in thread: Adam Machanic: "Re: How to find only updated columns in a trigger."
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 17 Mar 2004 15:34:27 +0100
You can use the UPDATE() function. See CREATE TRIGGER in Books Online.
-- Tibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp "Gopinath Munisifreddy" <Gopinath@Microsoft.com> wrote in message news:O0VvSuCDEHA.3348@TK2MSFTNGP11.phx.gbl... > Hi, > How to find only the columns which are updated in trigger. My table has > got around 60 coulmns. In a trigger i want to know what are the columns > updated when user executes an update statement. > > Thanks in advance. > Gopinath M > >
- Next message: Adam Machanic: "Re: How to find only updated columns in a trigger."
- Previous message: Johnmichael Monteith: "Append One Table To Another"
- In reply to: Gopinath Munisifreddy: "How to find only updated columns in a trigger."
- Next in thread: Adam Machanic: "Re: How to find only updated columns in a trigger."
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
