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-12 : 11:55:54
|
Nathan writes "I want a couple of things to happen each time an insert into a table takes place:
Here is the problem. Every time, I insert into a table, I want a select statement to be executed and the result also inserted into this table and then this inserted value deleted in this Table. But I want this to be recurive. Something like a Breath First Search.
I use the SQL server 7.0 from wrox (a great book) and saw something about the sp_doption to be turned on. Not much of details on this though.
Can you help please?" |
|
|
|
|
|
Recursive triggers