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 |
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
 Posted - 2008-06-05 : 12:08:19
|
| I tried the following, 1. Created a INSTEAD OF TRIGGER for INSERT 2. In the trigger, I have written a sql which inserts data in the same table3. When I do the INSERT on the table the data in the trigger gets inserted 4. I was sort of expecting a recursive loopIs this the normal behavior? ------------------------I think, therefore I am - Rene Descartes |
|
|
blindman
Master Smack Fu Yak Hacker
2365 Posts |
Posted - 2008-06-05 : 12:37:57
|
| Yes. INSTEAD OF triggers are never recursive.e4 d5 xd5 Nf6 |
 |
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2008-06-05 : 12:44:34
|
| Thanks!I have another question? How do you type - if you are blind?!------------------------I think, therefore I am - Rene Descartes |
|
|
|
blindman
Master Smack Fu Yak Hacker
2365 Posts |
Posted - 2008-06-05 : 12:49:48
|
| I have a seeing eye dog that went to night school to learn how to type. Works pretty well, though without opposable thumbs he relies upon me to hit the space bar with the tip of my cane.Woof.e4 d5 xd5 Nf6 |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-06-05 : 12:51:37
|
 |
|
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2008-06-05 : 12:58:48
|
quote:
Originally posted by blindman
I have a seeing eye dog that went to night school to learn how to type. Works pretty well, though without opposable thumbs he relies upon me to hit the space bar with the tip of my cane.Woof.e4 d5 xd5 Nf6
Ha ha! Gotcha…------------------------I think, therefore I am - Rene Descartes |
|
|
|
|
|
|
Mysterious INSTEAD OF TRIGGERS