Posted by Rico on 01/03/07 23:25

That's excellent! Thank you very much for your help Erland, that was
exactly what I needed! (that will make coding in VB much easier. ;)

Rick

"Erland Sommarskog" <esquel@sommarskog.se> wrote in message
news:Xns98ADF09B38EBDYazorman@127.0.0.1...
> Rico (you@me.com) writes:
>> I have a table that has a UserUpdated field which has a default value of
>> SUSER_SNAME(). This works great when the record is created, but I'd
>> like to also update this value when the record is changed. If I
>> understand things correctly, I'll need a trigger to do this, but I've
>> never created a trigger before. Is this an easy thing to accomplish?
>
> CREATE TRIGGER tbltri ON tbl FOR INSERT,UPDATE AS
> UPDATE tbl
> SET moduser = SYSTEM_USER
> FROM tbl t
> JOIN inserted i ON t.pkcol = i.pkcol
>
> SYSTEM_USER is the ANSI version of suser_sname() and easier to spell. :-)
>
> The table "inserted" is a virtual tables that holds the rows that
> were inserted or the after-image of the updated rows. There is also
> a table "deleted" which holds deleted rows and the before-image of
> updated rows.
>
> A trigger fires once per statement, so there can be many rows in these
> tables.
>
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
>
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]