Can I return an identity value to be used in an insert trigger on a table?

Click here to monitor SSC

<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>

SQLServerCentral is supported by Red Gate Software Ltd.

Log in :: Register :: Not logged in

<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>

Recent Posts

Popular Topics

Home

Home » Programming » General » Can I return an identity value to be used in...

Add to briefcase

12 posts, Page 2 of 2

««1 2

Can I return an identity value to be used in an insert trigger on a table?

Expand / Collapse

Author

Message

Posted Wednesday, February 06, 2013 2:50 PM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, February 07, 2013 7:20 AM
Points: 7, Visits: 24

Thanks for your help.
I'll admit the 'join' is much cleaner than the 'select'.

However, is this saving me an I/O to the database?

I was hoping that returning the identity value from the insert to the parent table, and using it as the data to update the child table would save me I/O.

Or is an I/O performed because the parent and child inserts are in the same transaction?

Post #1416745

Posted Wednesday, February 06, 2013 3:31 PM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, February 07, 2013 7:20 AM
Points: 7, Visits: 24

oops, dup.

Post #1416754

« Prev Topic | Next Topic »

Add to briefcase

12 posts, Page 2 of 2

««1 2

Permissions

Expand / Collapse