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 |
|
bubix
Starting Member
24 Posts |
 Posted - 2005-11-16 : 08:41:51
|
| I must have a before update trigger on a table. I know that "before update trigger" is remplaced by "instead of update" in SQL Server.But my problem is: I must have more than one instead of trigger on the same table but it cannot do that in SQL Server because only one instead of trigger by table is autorized.How can remplace instead of trigger to have more one trigger of this type(instead of) ???ThanksThanks |
|
|
Kristen
Test
22859 Posts |
Posted - 2005-11-16 : 15:43:06
|
| "I must have more than one instead of trigger"Why? What problem do you have that you are trying to solve? (or why do you need multiple triggers, rather than one (large) composite trigger?Kristen |
 |
|
|
bubix
Starting Member
24 Posts |
Posted - 2005-11-16 : 16:36:41
|
| Thanks Kriten,But sorry for this question, it is a stupidity.I think that we cannot have a trigger instead of update and a trigger instead of insert, on the same table.I test it and it pass.Really sorryBye |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2005-11-17 : 00:35:34
|
| Ah, OK, no worries. I thought you were meaning multiple instead of triggers on just INSERT, for example!Kristen |
|
|
|
|
|
|
Before Trigger