Solved

Trigger UPDATE from 'inserted'

Posted on 2012-03-16
2
259 Views
Last Modified: 2012-08-13
Hello,

I am trying to create a trigger which should monitor the table tbUsers. Once a record is inserted into tbUsers it should update the column of the table tbWatch 'LastLogged' with the current date/time from the server and also add the value of 1 to the column 'TimesLogged'. The table tbUsers and tbWatch connect on the column 'MAC' so obviously the update should happen only if the MAC value from the rows to be appended on tbUsers match those of tbWatch.

Many thanks
0
Comment
Question by:MissNicola
2 Comments
 
LVL 42

Accepted Solution

by:
dqmq earned 500 total points
ID: 37731946
CREATE TRIGGER YourTrigger ON tbUsers
AFTER INSERT
AS
BEGIN
UPDATE tbWatch
set LastLogged=getdate()
,TimesLogged=TimesLogged+1
FROM tbWatch w inner join inserted i on i.mac = w.mac
END
0
 

Author Comment

by:MissNicola
ID: 37732521
That was excellent! Many thanks!!!!
0

Featured Post

Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
This is used to tweak the memory usage for your computer, it is used for servers more so than workstations but just be careful editing registry settings as it may cause irreversible results. I hold no responsibility for anything you do to the regist…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…

813 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now