Never mind!
I'm being dense this morning.
All I had to do was:
CREATE TRIGGER tg_Update_Date
ON table
AFTER UPDATE
AS
UPDATE table
SET Date = GetDate()
WHERE Id = (SELECT Id FROM Inserted)
Thanks anyway.
Russel
Using Webmail for a better tomorrow ;)
>
> From: <[EMAIL PROTECTED]>
> Date: 2002/06/13 Thu AM 10:22:17 EDT
> To: CF-Community <[EMAIL PROTECTED]>
> Subject: MS SQL 2000 Trigger Help
>
> I need to create a trigger on an MS SQL 2000 table that update a date field when an
>UPDATE query is executed against the table. How do I set the WHERE portion of the
>SQL in the query?
>
> Here is what I have so far:
>
> CREATE TRIGGER tg_Update_Date
> ON table
> AFTER UPDATE
> AS
> SET Date = GetDate()
> WHERE Id = ?????
>
> What goes where I have the ????? ?
>
> Thanks in advance.
>
> Russel
>
>
>
______________________________________________________________________
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
