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-05-23 : 21:06:54
|
Andrew writes "How do I access the results of a trigger from a stored procedure? Maybe there's a better way to do this, but one example would be that I have a trigger to select max(ID) on insert. I could just do this from the stored procedure and not use a trigger, but sometimes inserts are done straight from Cold Fusion (without the stored procedure) so the trigger needs to run regardless.
This should be able to run on v.7 although I'm also looking for ammo to recommend an update wo SQL Server 2000.
Thank you very much,
- Andrew." |
|
|
|
|
|
Accessing trigger output from a stored procedure