Re: trigger question for the gurus

Article View: comp.databases.ms-sqlserver

Article #144

Back to comp.databases.ms-sqlserver Previous Next

#144

From: Bob Pfeiff
Date: Tue, 29 Sep 1998 00:00

8 lines
990 bytes

You can use If Update in an Update or Insert trigger to test if a column was
changed.  More in books online under "Create Trigger".

Hope this helps.

--
Bob Pfeiff
MCSD, SQL Server MVP

Technical Details

Message-ID: <eV63D$B79GA.193@uppssnewspub04.moswest.msn.net>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

References: <360fcb52.0@news.one.net>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10bbfe,9e2326f14a16e1f6
X-Google-Attributes: gid10bbfe,public
X-Google-Thread: ff490,9e2326f14a16e1f6
X-Google-Attributes: gidff490,public
X-Google-Thread: 11301e,9e2326f14a16e1f6
X-Google-Attributes: gid11301e,public
X-Google-Thread: 104de1,9e2326f14a16e1f6
X-Google-Attributes: gid104de1,public
From: "Bob Pfeiff" <bobp@spectrumtechnosp.com>
Subject: Re: trigger question for the gurus
Date: 1998/09/29
Message-ID: <eV63D$B79GA.193@uppssnewspub04.moswest.msn.net>
X-Deja-AN: 396208577
References: <360fcb52.0@news.one.net>
Newsgroups: comp.databases.ms-sqlserver,cz.comp.microsoft.sql,microsoft.public.sqlserver.datawarehouse,microsoft.public.sqlserver.programming
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3

Reply to Parent Message