I wrote a trigger for whenever an update occurs in the table. But the trigger is not executing after update. The db used is SQLServer.
create trigger mytrigger on t_emp after update
as
begin
select * from t_emp
end
Thanks
Asked
Active
Viewed 69 times
0
Alex Aza
- 73,821
- 25
- 151
- 132
Thomas Mathew
- 1,131
- 5
- 15
- 30
-
What do you expect the trigger to do? How do you know it is not executed? – Alex Aza Jun 22 '11 at 04:44
-
@Alex Aza :It should the retrieve the rows of the that particular table after update. – Thomas Mathew Jun 22 '11 at 04:47
-
What should it do with rows when rows are retrieved? – Alex Aza Jun 22 '11 at 04:48
-
@Alex Aza: if i am performing delete or update , its working. Can we use select query to display the updated row??? – Thomas Mathew Jun 22 '11 at 04:53
-
only with the OUTPUT clause, see my answer please – gbn Jun 22 '11 at 05:03
1 Answers
2
Triggers are used for further processing after UPDATEs or INSERTs etc, typically for history or audit tables, or for complex data integrity logic. Not for data retrieval. Triggers can break a lot of client code (see this on SO)
- To get the output of what you've just updated, use the OUTPUT clause.
- To get all rows from the table, use a second SELECT statement
