Solved

Trigger UPDATE from 'inserted'

Posted on 2012-03-16
2
262 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

Confronted with some SQL you don't know can be a daunting task. It can be even more daunting if that SQL carries some of the old secret codes used in the Ye Olde query syntax, such as: (+)     as used in Oracle;     *=     =*    as used in Sybase …
Composite queries are used to retrieve the results from joining multiple queries after applying any filters. UNION, INTERSECT, MINUS, and UNION ALL are some of the operators used to get certain desired results.​
Finding and deleting duplicate (picture) files can be a time consuming task. My wife and I, our three kids and their families all share one dilemma: Managing our pictures. Between desktops, laptops, phones, tablets, and cameras; over the last decade…

738 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