INSTEAD OF trigger

[User 4700810]

Hi all, I want to create a trigger relating to table Demo and table UpdateInfo. UpdateInfo is created as following:

CREATE TABLE UpdateInfo
(ID int primary key,
new int,
click int)

The task for this trigger is whenever there is a row inserted to Demo, there is an update in field [new] of UpdateInfo ( new = new +1) , but it wll just work, for example, from 1:00 am to 6:00 am. If this has been done, I then want to customize the time from an aspx page. I think I should start with INSTEAD OF trigger but I am lacking in experiences about it. Could you give me any suggestion? Thank you so much!

[David Skelly]

How is this different from your question yesterday about triggers in a certain time period?

[User 4700810]

yep, But the answer I got yesterday is still dubious. I am still having no ideas about how to check time & check by which syntax. The question today is one in my effort to find out solution for the question of yesterday, but in a different form :D I think INSTEAD OF trigger can help me to sovle prolem. That is the reason for the question today ^^ However, if you think just a standard trigger is quite enough to solve my problem, could you give me a more specific example? Thanks for your help!

modified on Wednesday, December 9, 2009 8:36 AM