Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: Enterprise
Expertise: All
Apr 15, 1999

Do You Know What Your Identity Is?

Everyone by now is familiar with how to create auto increment keys in SQL Server--just define an integer column with identity (start,increment) and you are set. To create a new parent record and then insert a related record into a child table, you perform the insert into the parent, then execute a select @@identity to capture the auto increment number used by the system and carry over that number into the second insert into the child. But what happens if your system has a trigger on the parent table that inserts audit information whenever an insert happens into an audit log? If the audit table also has an auto increment key, the select @@identity will return the number used by the audit log, not the parent record.
Joseph Lax
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date