R RA Nov 25, 2003 #1 Is it guaranteed to give the last identity value generated by the insert, no matter if a trigger has added another row? Thanks, Ronen
Is it guaranteed to give the last identity value generated by the insert, no matter if a trigger has added another row? Thanks, Ronen
M Miha Markic Nov 25, 2003 #2 Yes, because trigger is in different scope (according to SQL Server help files).
