Login | Register   
RSS Feed
Download our iPhone app
Browse DevX
Sign up for e-mail newsletters from DevX

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



Application Security Testing: An Integral Part of DevOps

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.



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