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 |
|
jgrant
Yak Posting Veteran
69 Posts |
 Posted - 2007-08-16 : 15:00:18
|
| I am not very familiar with triggers. I was wondering if its possible to use a trigger to determine when a column of a particular row and table is altered or updated to then grab another piece of data from that same record and then call another sp?The Yak Village Idiot |
|
|
blindman
Master Smack Fu Yak Hacker
2365 Posts |
Posted - 2007-08-16 : 15:03:54
|
| Yes, it is possible. But Triggers may affect multiple records, while chances are your Sproc is set up to deal with only one at a time. So I would advise copying the logic from your sproc into the trigger instead, always being mindful that your code must support multi-record transactions.e4 d5 xd5 Nf6 |
 |
|
|
ashley.sql
Constraint Violating Yak Guru
299 Posts |
Posted - 2007-08-16 : 15:04:55
|
| use books online. search for triggers. there are many examples to learn fromAshley Rhodes |
|
|
|
jgrant
Yak Posting Veteran
69 Posts |
Posted - 2007-08-16 : 15:42:25
|
| Okay, thanks for the posts. I will try that.The Yak Village Idiot |
|
|
|
ashley.sql
Constraint Violating Yak Guru
299 Posts |
Posted - 2007-08-16 : 15:45:26
|
| The Yak Village IdiotThats Funny and Innovative..........Ashley Rhodes |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-08-16 : 15:46:47
|
> The Yak Village Moron Sounds Betterouch!  _______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
ashley.sql
Constraint Violating Yak Guru
299 Posts |
Posted - 2007-08-16 : 16:11:55
|
| Too bad I can't see his picture. You can change yours to MORONAshley Rhodes |
|
|
|
|
|
|
Database Triggers