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 |
|
DKV
Starting Member
5 Posts |
 Posted - 2010-08-20 : 22:31:51
|
| I have a reports table with column report id and and report version. I created a trigger on this table to execute an application to do some processing each time a row is inserted in reports table. I need to pass the new report id execute this application from the trigger. How do I get the report id from the row that was inserted?Thanks.D |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-08-21 : 04:26:49
|
| It will be there in INSERTED table. Just add trigger for INSERT and use select reportid FROM INSERTED to get the generated id.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
getting a value from the inserted row in trigger