Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Simply
Starting Member
2 Posts |
 Posted - 2009-12-09 : 02:52:21
|
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!My name is Mai Phuong. I'm simple, doing sth simply. |
|
|
RyanRandall
Master Smack Fu Yak Hacker
1074 Posts |
Posted - 2009-12-09 : 05:22:26
|
| Sounds like you just need a standard trigger. Why do you think you need an INSTEAD OF trigger?Ryan Randall - Yak of all tradesSolutions are easy. Understanding the problem, now, that's the hard part. |
 |
|
|
Simply
Starting Member
2 Posts |
Posted - 2009-12-09 : 08:35:17
|
| Maybe the problem of mine is I do not know how to check time? Would you give me more specific example?Thank for your helping!My name is Mai Phuong. I'm simple, doing sth simply. |
|
|
|
|
|
|
INSTEAD OF trigger