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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-02-21 : 12:21:04
|
Sam writes "Hi,
I'm inserting a record into a table. This table has some 10 fields including 2 date fields. But before the insert happens i want to perform certain operations and then change the value of the date fields. Any ideas?
Insert into this table happens from various places and that's one reason i want to use a trigger. I know i can accomplish this by using an update stmt inside the "insert trigger" but their might be some updates also to this table. In which case i need to write an "update trigger" also... wouldn't this lead to recursiveness?
Any advice is appreciated.
Thanks
Sam" |
|
|
|
|
|
Before Insert Trigger