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 - 2006-01-12 : 08:59:08
|
| Yigit writes ""identity primary key column" value is always 1 in the inserted table. i need to get the actual value of the primary key by a trigger. isn't it possible to use triggers to get these identity pk values? or isn't it possible to get after transaction values?" |
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2006-01-12 : 09:50:31
|
| you could use the scope_identity() functionread up books online |
 |
|
|
|
|
|
triggers and identity primary keys