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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 SQL Server Insert Returning ID

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-03-09 : 08:23:06
Drew writes "How can I best get the id of a just inserted database record when there are triggers on the table in SQL Server 7?

I have used the code that returns the @@identity but I think that I have found that it doesn't work when there are some triggers running on that table."
   

- Advertisement -